CREATE PROCEDURE 存储过程名 AS DECLARE @i INT SELECT @i=1 DECLARE KILL_CUR SCROLL CURSOR FOR SELECT SPID FROM sysprocesses WHERE DBID=DB_ID('数据库名')
OPEN KILL_CUR IF @@CURSOR_ROWS = 0 GOTO END_KILL_CUR FETCH FIRST FROM eTomEx_Data_Out_CUR INTO @sSPID EXEC('KILL '+@sSPID) WHILE @i< @@CURSOR_ROWS BEGIN FETCH NEXT FROM KILL_CUR INTO @sSPID EXEC('KILL '+@sSPID) SELECT @i=@i+1 END END_KILL_CUR: CLOSE KILL_CUR DEALLOCATE KILL_CUR
(没有测试环境,写不出具体的操作)
AS DECLARE @i INT
SELECT @i=1 DECLARE KILL_CUR SCROLL CURSOR
FOR
SELECT SPID
FROM sysprocesses
WHERE DBID=DB_ID('数据库名')
OPEN KILL_CUR
IF @@CURSOR_ROWS = 0 GOTO END_KILL_CUR
FETCH FIRST FROM eTomEx_Data_Out_CUR INTO @sSPID
EXEC('KILL '+@sSPID)
WHILE @i< @@CURSOR_ROWS
BEGIN
FETCH NEXT FROM KILL_CUR INTO @sSPID
EXEC('KILL '+@sSPID)
SELECT @i=@i+1
END
END_KILL_CUR:
CLOSE KILL_CUR
DEALLOCATE KILL_CUR