有表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
uj5u.com熱心網友回復:
begin transelect * from test(updlock) where id=1
waitfor delay '00:00:10'
update test set flag=1 where id=1 and flag=0
commit
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/46283.html
標籤:基礎類
下一篇:python的格式轉化
