select top 1 * from callback with (updlock) order by newid()
注意:这个语句是锁整个表的
select * from callback with (updlock) where id=1
这是行级锁,只锁一行
select top 1 * from callback with (updlock) order by newid()
注意:这个语句是锁整个表的
select * from callback with (updlock) where id=1
这是行级锁,只锁一行