-- 查询死锁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'