查询死锁进程和表
SELECT request_session_id AS spid , OBJECT_NAME(resource_associated_entity_id) AS ‘table‘ FROM sys.dm_tran_locks WHERE resource_type = ‘OBJECT‘;
杀死进程
kill [SPID]
SQL Server查询死锁，杀死进程解决死锁
原文：https://www.cnblogs.com/weifeng123/p/10973331.html
