sql表里面某条记录被锁死，无法删除解决方案

-- 查当前被阻塞的会话
SELECT
r.session_id,
r.status,
r.command,
r.wait_type,
r.wait_time,
r.blocking_session_id,
t.text AS sql_text
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t
WHERE r.session_id > 50
AND (r.blocking_session_id > 0 OR r.wait_type LIKE 'LCK%')

-- 查 15715 相关的锁
SELECT
l.request_session_id,
l.resource_type,
l.request_mode,
l.request_status,
t.text
FROM sys.dm_tran_locks l
JOIN sys.dm_exec_connections c ON l.request_session_id = c.session_id
CROSS APPLY sys.dm_exec_sql_text(c.most_recent_sql_handle) t
WHERE l.resource_associated_entity_id = OBJECT_ID('tb_bs_PurOrderdtl')

KILL 86