declare @spid varchar(10)
declare cursorspid cursor for --定义游标cursorspid
select spid from master.dbo.sysprocesses where status ='sleeping' and loginame = 'sa'--使用游标的对象(根据需要填入状态值及用户)
open cursorspid --打开游标
fetch next from cursorspid into @spid --将游标向下移行,获取的数据放入之前定义的变量@spid中
while @@fetch_status=0 --判断是否成功获取数据
begin
exec ('kill '+ @spid);
fetch next from cursorspid into @spid--将游标向下移行
end
close cursorspid
deallocate cursorspid