22,210
社区成员
发帖
与我相关
我的任务
分享
--生成测试表Ta
if not object_id('Ta') is null
drop table Ta
go
create table Ta(ID int Primary key,Col1 int,Col2 nvarchar(10))
insert Ta
select 1,101,'A' union all
select 2,102,'B' union all
select 3,103,'C'
GO
--窗口1
BEGIN TRAN
SELECT * FROM Ta WITH(UPDLOCK,READPAST) WHERE ID=1
--ROLLBACK
--窗口2
BEGIN TRAN
SELECT * FROM Ta WITH(UPDLOCK,READPAST) WHERE ID=1
--ROLLBACK