語法:
代碼: 選擇全部
declare @spid varchar(10), @cmd varchar(200), @databasename varchar(255)
select @databasename='TestDB'
declare c1 cursor for
select spid from sysprocesses sp inner join sysdatabases sd on sp.dbid=sd.dbid
where sd.name=@databasename
open c1
fetch next from c1 into @spid
while(@@fetch_status=0)
begin
print @spid
select @cmd = 'kill '+@spid
execute (@cmd)
fetch next from c1 into @spid
end
close c1
deallocate c1