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