并发连接

连接1:

set lock_timeout 1000
waitfor time '12:08'
update mm set istop=0 where id in (select top 1 id from mm with(readpast))

连接2:

set lock_timeout 1000
waitfor time '12:08'
update mm set istop=0 where id in (select top 1 id from mm with(readpast))

没有出现并发问题 均可更改并且没有发生死锁