-- 查询死锁
select
request_session_id spid,
OBJECT_NAME(resource_associated_entity_id) tableName
from
sys.dm_tran_locks
where
resource_type='OBJECT'
--杀死死锁进程
kill 354
创造死锁条件
开两个查询窗口
BEGIN TRANSACTION--开始事务
update job set creator='00000' where id='001'
WAITFOR DELAY '02:00';
select * from job where id='001'
欢迎转载，请注明来自白菜卖故事>>本文地址：http://www.bcmgs.com/758
0 还没人赞过...