use master;godeclare @temp nvarchar(20)declare myCurse cursorforselect spidfrom sys.sysprocesseswhere dbid=DB_ID('数据库名称')--待清理的数据库open myCursefetch next from myCurse into @tempwhile @@FETCH_STATUS=0beginexec('kill '+ @temp)fetch next from myC…
use master;
go
declare @temp nvarchar(20)
declare myCurse cursor
for
select spid
from sys.sysprocesses
where dbid=DB_ID('数据库名称')--待清理的数据库
open myCurse
fetch next from myCurse into @temp
while @@FETCH_STATUS=0
begin
exec('kill '+ @temp)
fetch next from myCurse into @temp
end
close myCurse
deallocate myCurse;
扫一扫在手机打开
评论
已有0条评论
0/150
提交
热门评论
相关推荐
