mssqlÊý¾Ý¿â»Ö¸´ÎÊÌ⣬¼±
ÎÒÏëÔÚJspÒ³ÃæÀïÃæ»Ö¸´Êý¾Ý¿â£¬²Î¿¼ÁËһЩ×ö·¨£¬Óô洢¹ý³Ì¶Ï¿ªÊý¾Ý¿âµÄÁ´½Ó¡£
/*
¹Ø±ÕÓû§´ò¿ªµÄ½ø³Ì´¦Àí
*/
use master
go
create proc killspid (@dbname varchar(20))
as
begin
declare @sql nvarchar(500),@temp varchar(1000)
declare @spid int
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
begin
set @temp='kill '+rtrim(@spid)
exec(@temp)
Ïà¹ØÎÊ´ð£º
ÏÖÓÐÒ»¸öASP+mssqlµÄÍøÕ¾£¬±»¹ÒÂíÁË£¬½«ÀïÃæÒ»¸ö±íÖеÄntext×ֶιÒÂí¹ÒÂí£¬¡°<script src=http://ľÂíµØÖ·></script>¡±,µÄ·½Ê½ÊÇ£¬²»¶ÏµØÐ޸ĸÃ×ֶεÄÖµ£¬Ö±½Ó¼ÓÔÚ×îºóµÄ£¬Ê±¼ä³¤ÁË£¬¿ÉÒÔ¿´µ½¸Ã×Ö¶ÎÖÐÓÐ ......
×î½üÏÂÃæ·´Ó¦Ëµ³ÌÐòÒì³£
È»ºó´ò¿ªÊý¾Ý¿âÒ»¿´
·¢Ïֺܶà±í¶¼"Ö»¶Á"״̬??
ÓÃsaµÇ½ҲÊÇ...
ºÜÆæ¹Ö°¡..
´óÅ£ÖªµÀÊÇʲôÔÒòÂð?
Ô¸Òâ³ö¸ß·ÖÇó
˽â¾öÁË
¸ø200·Ö!!
Êý¾Ý¿â³öÎÊÌâÁË?
ÒýÓÃ
×î½üÏÂÃæ ......
accessʱ²éѯËÙ¶È»¹Âù¿ìµÄ£¬ÏÖÔÚת³ÉmssqlÁË£¬Êý¾ÝÁ¿²¢²»´ó£¬Í¨³£Êý¾ÝÁ¿¶àЩµÄ¾ÍÊǼ¸Ç§Ìõ£¬µ±È«²¿ÁгöÊý¾ÝʱËÙ¶ÈÒ²²»Âý£¬¾ÍÊǰ´Ìõ¼þËÑË÷ʱ¾ÍÂýÁË£¬ÇëÎÊÊDz»ÊǸúlikeÓйذ¡£¬µ«ÒÔǰÓÃaccessÂù¿ìµÄ°¡£¬Ò²½¨Á¢ÁËË÷ÒýÁË ......
ÎÒÔÚMSSQL¹ÜÀíÆ÷Àï°Ñн¨×Ö¶Îstr
ÔÚĬÈÏÖµ»ò°ó¶¨ÄÇÀïÎÒÌîдÁË0
È»ºóÎÒ·¢ÏÖ¡£Èç¹ûÎÒÔÚÔö¼Ó¼Ç¼ʱ¡£Õâ¸öSTR²¢²»ÊÇĬÈϵÄ0¶øÊÇNULLÔõô»ØÊ£¿£¨ÔÚÔö¼Ó×Ö¶Îʱ¡£ÎÒûÓмÈërs("str")µÄÖµ¡£Ô±¾Ò ......