-- 查询死锁 select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT'
--杀死死锁进程 kill spid
DBCC INPUTBUFFER
显示从客户机发送到服务器的最后一个语句 DBCC INPUTBUFFER(52);
-- 查询死锁 select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT'
--杀死死锁进程 kill spid
DBCC INPUTBUFFER
显示从客户机发送到服务器的最后一个语句 DBCC INPUTBUFFER(52);