22,300
社区成员




begin tran
select * from lives with(updlock)
update lives set play='羽毛球'
waitfor delay '0:0:5'
select * from dbo.Earth with(updlock)
update dbo.Earth set Animal='老虎'
commit tran
begin tran
select * from dbo.Earth with(updlock)
update Earth set Animal='老虎'
waitfor delay '0:0:5'
select * from lives with(updlock)
update lives set play='羽毛球'
commit tran