循环杀进程

DECLARE @SPID AS INT
DECLARE @COUNT AS INT=0
 
DECLARE curSPID CURSOR FOR
SELECT SPID
FROM master..sysprocesses  
-----添加要杀进程的条件
WHERE   spid>50  and status=‘SLEEPING‘ and dbid=DB_ID(‘AdventureWorks2016‘)

 
OPEN curSPID
FETCH NEXT FROM curSPID INTO @SPID
 
WHILE @@FETCH_STATUS = 0
BEGIN
    EXEC(‘KILL ‘+ @SPID)
    SET @COUNT+=1
    PRINT ‘KILL ‘+ CAST(@SPID AS VARCHAR)
    FETCH NEXT FROM curSPID INTO @SPID
END
PRINT ‘KILL COUNT：‘+ CAST(@COUNT AS VARCHAR)
CLOSE curSPID
DEALLOCATE curSPID