select * from test where id=1
waitfor delay '00:00:10'
update test set flag=1 where id=1 and flag=0
当UPDATE语句执行完才能让另外的人取到
select * from test where id=1
...全文
711打赏收藏
关于行锁的问题
有表TEST select * from test where id=1 waitfor delay '00:00:10' update test set flag=1 where id=1 and flag=0 当UPDATE语句执行完才能让另外的人取到 select * from test where id=1