sqlserver2008行锁

select * from tablename WITH (UPDLOCK) where Id=#value#