摘要： 连接1:set lock_timeout 1000waitfor time '12:08'update mm set istop=0 where id in (select top 1 id from mm with(readpast))连接2:set lock_timeout 1000waitfor time '12:08'update mm set istop=0 where id in (select top 1 id from mm with(readpast))没有出现并发问题 均可更改并且没有发生死锁 阅读全文