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