asp.net C#Êý¾Ý¿â»¹Ô­ÎÊÌâ - .NET¼¼Êõ / C#

ÎÒÊÇÓô洢¹ý³Ì°ÑÁ¬½Ó½ø³Ìɱµô£¬È»ºó½øÐл¹Ô­¡£ÏÂÃæÊÇÎÒ´æ´¢¹ý³ÌµÄ´úÂ룬ÓдíÎ󡣡£Çë°ï°ïÎÒ°É¡£¡£Ð»Ð»ÁË¡£¡£Ð¡µÜÊÇÇ×ÊÖ¡£¡£ 
C# code:


ALTER PROCEDURE dbo.Kills
as declare @dbname varchar(20)
set @dbname='FIUMS' ---ÕâÊÇÊý¾Ý¿âÃû³Æ
declare @sql nvarchar(500)
declare @spid int--SPID ÖµÊǵ±Óû§½øÐÐÁ¬½ÓʱָÅɸø¸ÃÁ¬½ÓµÄÒ»¸öΨһµÄÕûÊý
set @sql='declare getspid cursor for
select spid from sysprocesses where dbid=db_id(''' + @dbname + ''')'
exec (@sql)
open getspid
fetch next from getspid into @spid
while @@fetch_status<>-1--Èç¹ûFETCH Óï¾äûÓÐÖ´ÐÐʧ°Ü»ò´ËÐв»ÔÚ½á¹û¼¯ÖС£
begin
exec('kill '+ @spid)--ÖÕÖ¹Õý³£Á¬½Ó
fetch next from getspid into @spid
end
close getspid
deallocate getspid




´íÎóÐÅÏ¢£º¶ÔÏóÃû¡®sysprocesses¡¯ÎÞЧ£¬ÃûΪ¡®getspid¡¯µÄÓα겻´æÔÚ£¬ÃûΪ¡®getspid¡¯µÄÓα겻´æÔÚ£¬ÃûΪ¡®getspid¡¯µÄÓα겻´æÔÚ¡£¡£¡£¡£¡£

---

ÓαêûÉùÃ÷°É£¬µ¥¶ÀÄÏÃ÷ÊÔÊÔ¿´ÄØ

---

CREATE PROC SP_DBRestore
 @DBNAME NVARCHAR(500), 
 @PATH NVARCHAR(500) 
AS
--¹Ø±ÕÓû§Á¬½Ó
BEGIN 
DECLARE @Sql NVARCHAR(4000);
SET @Sql = N'DECLARE @spid VARCHAR(20) 
DECLARE #spid CURSOR FOR SELECT spid=cast(spid AS VARCHAR(20)) from master..sysprocesses WHERE dbid=db_id('''+@dbname+''') 

OPEN #spid 
FETCH NEXT from #spid INTO @spid&n