34,838
社区成员




declare @a int
while getdate()<'2008-03-17 18:22:01'
begin
set @a=0
end
begin transaction
while @a<100000
begin
update t1 set name='我' where id=2
set @a=@a+1
end
update t2 set dt=getdate() where id=1
commit
declare @a int
while getdate()<'2008-03-17 18:22:02'
begin
set @a=0
end
begin transaction
while @a<100000
begin
update t2 set dt=getdate() where id=(select top 1 id from t1 where name='我')
set @a=@a+1
end
commit