27,579
社区成员
发帖
与我相关
我的任务
分享
--s1
create table ##t(id int)
insert into ##t values(1)
begin tran t1
update ##t set id = 2
--s2
select * from sys.dm_tran_locks
where resource_associated_entity_id = object_id ('tempdb..##t')
kill 72
select * from sys.dm_tran_locks
where resource_associated_entity_id = object_id ('tempdb..##t')
完全符合要求,请给分