declare @sql varchar(100)while 1=1
beginselect top 1 @sql = 'kill '+cast(spid as varchar(3))
from master..sysprocesses
where spid > 50 and spid <> @@spid if @@rowcount = 0
breakexec(@sql)
end
再使试试。
beginselect top 1 @sql = 'kill '+cast(spid as varchar(3))
from master..sysprocesses
where spid > 50 and spid <> @@spid if @@rowcount = 0
breakexec(@sql)
end
再使试试。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货