摘要:
SELECT a.spid,z.max_date,a.kcshl FROM spkfjc a inner join (SELECT a.spid AS spid ,MAX(b.rq) AS max_date FROM spkfjc a JOIN splsk b ON a.spid=b.spid WH 阅读全文
摘要:
查询出来 select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT 杀死死锁进程 ki 阅读全文