,convert(sysname, rtrim(loginame)) ,last_batch
from#Temp2
whereblocked >0
--保存阻塞的源头
insertinto#Temp(spid ,status ,hostname ,program_name ,cmd ,cpu ,physical_io ,blocked ,dbid
,loginame ,last_batch )
SELECTspid ,status ,hostname ,program_name ,cmd ,cpu ,physical_io ,blocked ,dbid
,convert(sysname, rtrim(loginame)) ,last_batch
from#Temp2
wherespid in(selectblocked from#Temp)
andspid notin(selectspid from#Temp)
select@spid=min(spid) from#Temp
|