循环杀进程

最新推荐文章于 2023-03-09 13:26:58 发布

weixin_30587927

最新推荐文章于 2023-03-09 13:26:58 发布

阅读量136

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/JinweiChang/p/10450225.html

本文介绍了一段SQL脚本，用于批量杀死在特定数据库（如AdventureWorks2016）中处于睡眠状态的进程。通过声明变量和游标，此脚本能够遍历符合条件的进程并逐一执行KILL命令。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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