摘要:
准备数据,插入1w条数据 create table locktest(id int primary key identity(1,1))gobegin traninsert locktest default valuesgo 10000commit 执行顺序如下,在第三部的时候会出现死锁 执行顺序 session1 session2 1 begin trandelete from locktest where id=2 2 set transaction isolation level repeatable readbegin transelect * from locktest where 阅读全文
posted @ 2011-07-19 12:48
stswordman
阅读(762)
评论(1)
推荐(1)
浙公网安备 33010602011771号