摘要:
WITH ProcessCTE(blocked) AS ( SELECT spid FROM sys.sysprocesses )SELECT a.*FROM (SELECT TEXT,AA.* FROM sys.sysprocesses AACROSS APPLY sys.dm_exec_sql_ 阅读全文
摘要:
WITH ProcessCTE(blocked) AS ( SELECT blocked FROM sys.sysprocesses WHERE blocked>0 union SELECT spid FROM sys.sysprocesses WHERE blocked>0)SELECT a.* 阅读全文