sqlserver2008行锁

select * from tablename WITH (UPDLOCK) where Id=#value#
原文地址:https://www.cnblogs.com/fuyuanming/p/5865253.html