ÏÖÔÚÖ÷Á÷µÄÍøÕ¾¿ª·¢ÓïÑÔÎÞÍâºõasp¡¢php¡¢asp.net¡¢jspµÈ¡£
ÍøÒ³´Ó¿ªÊ¼¼òµ¥µÄhmtlµ½¸´ÔӵķþÎñÓïÑÔ£¬×ß¹ýÁË10¶à¸öÄêÍ·£¬¸÷ÖÖ¼¼Êõ²ã³ö²»Çµ¥¸öµÄÖ÷Á÷¼¼ÊõÒ²ÔÚ²»¶Ï·Ðµİ汾£¬ÏÖÔÚ·ÖÎöϸ÷ÖÖÓïÑÔµÄÇø±ð¡¢ÓÅÊÆ¡¢ÁÓÊÆ¡¢¿ª·¢×¢ÒâÊÂÏ
HTML:µ±È»ÕâÊÇÍøÒ³×î»ù±¾µÄÓïÑÔ,ÿһ¸ö·þÎñÆ÷ÓïÑÔ¶¼ÐèÒªËüµÄÖ§³Ö,Ҫѧϰ,Õâ¸ö¿Ï¶¨ÊÇ¿ªÊ¼,²»ËµÁË.
Ö÷Á÷ÍøÕ¾¿ª·¢ÓïÑÔÖ®ASP:ASPÊÇ΢Èí£¨Microsoft£©Ëù¿ª·¢µÄÒ»ÖÖºǫ́½Å±¾ÓïÑÔ£¬ËüµÄÓï·¨ºÍVisual BASICÀàËÆ£¬¿ÉÒÔÏñSSI£¨Server Side Include£©ÄÇÑù°Ñºǫ́½Å±¾´úÂëÄÚǶµ½HTMLÒ³ÃæÖС£ËäÈ»ASP¼òµ¥Ò×Ó㬵«ÊÇËü×ÔÉí´æÔÚ×ÅÐí¶àȱÏÝ£¬×îÖØÒªµÄ¾ÍÊǰ²È«ÐÔÎÊÌ⡣ĿǰÔÚ΢ÈíµÄ .net Õ½ÂÔÖÐÐÂÍÆ³öµÄASP.net ½è¼øÁËJava¼¼ÊõµÄÓŵ㣬ʹÓÃC Sharp (C#) ÓïÑÔ×÷ΪASP.netµÄÍÆ¼öÓïÑÔ£¬Í¬Ê±¸Ä½øÁËÒÔǰASPµÄ°²È«ÐÔ²îµÈȱµã¡£µ«ÊÇ£¬Ê¹ÓÃASP/ASP.netÈÔÓÐÒ»¶¨µÄ¾ÖÏÞÐÔ£¬ÒòΪ´ÓijÖֽǶÈÀ´ËµËüÃÇÖ»ÄÜÔÚ΢ÈíµÄ Windows NT/2000/XP + IISµÄ·þÎñÆ÷ƽ̨ÉÏÁ¼ºÃÔËÐУ¨ËäÈ»ÏñChilliSoftÌṩÁËÔÚUNIX/LinuxÉÏÔËÐÐASPµÄ½â¾ö·½°¸£¬µ«ÊÇĿǰASPÔÚUNIX/LinuxÉϵÄÓ¦ÓÿÉÒÔ˵¼¸ºõΪ0£©¡£ËùÒÔÆ½Ì¨µÄ¾ÖÏÞÐÔºÍASP×ÔÉíµÄ°²È«ÐÔÏÞÖÆÁËASPµÄ¹ã·ºÓ¦Óá£
ASPÔÚÖ´ÐеÄʱºò£¬ÊÇÓÉIISµ÷ÓóÌÐòÒýÇ ......
ÏÖÔÚÖ÷Á÷µÄÍøÕ¾¿ª·¢ÓïÑÔÎÞÍâºõasp¡¢php¡¢asp.net¡¢jspµÈ¡£
ÍøÒ³´Ó¿ªÊ¼¼òµ¥µÄhmtlµ½¸´ÔӵķþÎñÓïÑÔ£¬×ß¹ýÁË10¶à¸öÄêÍ·£¬¸÷ÖÖ¼¼Êõ²ã³ö²»Çµ¥¸öµÄÖ÷Á÷¼¼ÊõÒ²ÔÚ²»¶Ï·Ðµİ汾£¬ÏÖÔÚ·ÖÎöϸ÷ÖÖÓïÑÔµÄÇø±ð¡¢ÓÅÊÆ¡¢ÁÓÊÆ¡¢¿ª·¢×¢ÒâÊÂÏ
HTML:µ±È»ÕâÊÇÍøÒ³×î»ù±¾µÄÓïÑÔ,ÿһ¸ö·þÎñÆ÷ÓïÑÔ¶¼ÐèÒªËüµÄÖ§³Ö,Ҫѧϰ,Õâ¸ö¿Ï¶¨ÊÇ¿ªÊ¼,²»ËµÁË.
Ö÷Á÷ÍøÕ¾¿ª·¢ÓïÑÔÖ®ASP:ASPÊÇ΢Èí£¨Microsoft£©Ëù¿ª·¢µÄÒ»ÖÖºǫ́½Å±¾ÓïÑÔ£¬ËüµÄÓï·¨ºÍVisual BASICÀàËÆ£¬¿ÉÒÔÏñSSI£¨Server Side Include£©ÄÇÑù°Ñºǫ́½Å±¾´úÂëÄÚǶµ½HTMLÒ³ÃæÖС£ËäÈ»ASP¼òµ¥Ò×Ó㬵«ÊÇËü×ÔÉí´æÔÚ×ÅÐí¶àȱÏÝ£¬×îÖØÒªµÄ¾ÍÊǰ²È«ÐÔÎÊÌ⡣ĿǰÔÚ΢ÈíµÄ .net Õ½ÂÔÖÐÐÂÍÆ³öµÄASP.net ½è¼øÁËJava¼¼ÊõµÄÓŵ㣬ʹÓÃC Sharp (C#) ÓïÑÔ×÷ΪASP.netµÄÍÆ¼öÓïÑÔ£¬Í¬Ê±¸Ä½øÁËÒÔǰASPµÄ°²È«ÐÔ²îµÈȱµã¡£µ«ÊÇ£¬Ê¹ÓÃASP/ASP.netÈÔÓÐÒ»¶¨µÄ¾ÖÏÞÐÔ£¬ÒòΪ´ÓijÖֽǶÈÀ´ËµËüÃÇÖ»ÄÜÔÚ΢ÈíµÄ Windows NT/2000/XP + IISµÄ·þÎñÆ÷ƽ̨ÉÏÁ¼ºÃÔËÐУ¨ËäÈ»ÏñChilliSoftÌṩÁËÔÚUNIX/LinuxÉÏÔËÐÐASPµÄ½â¾ö·½°¸£¬µ«ÊÇĿǰASPÔÚUNIX/LinuxÉϵÄÓ¦ÓÿÉÒÔ˵¼¸ºõΪ0£©¡£ËùÒÔÆ½Ì¨µÄ¾ÖÏÞÐÔºÍASP×ÔÉíµÄ°²È«ÐÔÏÞÖÆÁËASPµÄ¹ã·ºÓ¦Óá£
ASPÔÚÖ´ÐеÄʱºò£¬ÊÇÓÉIISµ÷ÓóÌÐòÒýÇ ......
ÏÖÔÚÖ÷Á÷µÄÍøÕ¾¿ª·¢ÓïÑÔÎÞÍâºõasp¡¢php¡¢asp.net¡¢jspµÈ¡£
ÍøÒ³´Ó¿ªÊ¼¼òµ¥µÄhmtlµ½¸´ÔӵķþÎñÓïÑÔ£¬×ß¹ýÁË10¶à¸öÄêÍ·£¬¸÷ÖÖ¼¼Êõ²ã³ö²»Çµ¥¸öµÄÖ÷Á÷¼¼ÊõÒ²ÔÚ²»¶Ï·Ðµİ汾£¬ÏÖÔÚ·ÖÎöϸ÷ÖÖÓïÑÔµÄÇø±ð¡¢ÓÅÊÆ¡¢ÁÓÊÆ¡¢¿ª·¢×¢ÒâÊÂÏ
HTML:µ±È»ÕâÊÇÍøÒ³×î»ù±¾µÄÓïÑÔ,ÿһ¸ö·þÎñÆ÷ÓïÑÔ¶¼ÐèÒªËüµÄÖ§³Ö,Ҫѧϰ,Õâ¸ö¿Ï¶¨ÊÇ¿ªÊ¼,²»ËµÁË.
Ö÷Á÷ÍøÕ¾¿ª·¢ÓïÑÔÖ®ASP:ASPÊÇ΢Èí£¨Microsoft£©Ëù¿ª·¢µÄÒ»ÖÖºǫ́½Å±¾ÓïÑÔ£¬ËüµÄÓï·¨ºÍVisual BASICÀàËÆ£¬¿ÉÒÔÏñSSI£¨Server Side Include£©ÄÇÑù°Ñºǫ́½Å±¾´úÂëÄÚǶµ½HTMLÒ³ÃæÖС£ËäÈ»ASP¼òµ¥Ò×Ó㬵«ÊÇËü×ÔÉí´æÔÚ×ÅÐí¶àȱÏÝ£¬×îÖØÒªµÄ¾ÍÊǰ²È«ÐÔÎÊÌ⡣ĿǰÔÚ΢ÈíµÄ .net Õ½ÂÔÖÐÐÂÍÆ³öµÄASP.net ½è¼øÁËJava¼¼ÊõµÄÓŵ㣬ʹÓÃC Sharp (C#) ÓïÑÔ×÷ΪASP.netµÄÍÆ¼öÓïÑÔ£¬Í¬Ê±¸Ä½øÁËÒÔǰASPµÄ°²È«ÐÔ²îµÈȱµã¡£µ«ÊÇ£¬Ê¹ÓÃASP/ASP.netÈÔÓÐÒ»¶¨µÄ¾ÖÏÞÐÔ£¬ÒòΪ´ÓijÖֽǶÈÀ´ËµËüÃÇÖ»ÄÜÔÚ΢ÈíµÄ Windows NT/2000/XP + IISµÄ·þÎñÆ÷ƽ̨ÉÏÁ¼ºÃÔËÐУ¨ËäÈ»ÏñChilliSoftÌṩÁËÔÚUNIX/LinuxÉÏÔËÐÐASPµÄ½â¾ö·½°¸£¬µ«ÊÇĿǰASPÔÚUNIX/LinuxÉϵÄÓ¦ÓÿÉÒÔ˵¼¸ºõΪ0£©¡£ËùÒÔÆ½Ì¨µÄ¾ÖÏÞÐÔºÍASP×ÔÉíµÄ°²È«ÐÔÏÞÖÆÁËASPµÄ¹ã·ºÓ¦Óá£
ASPÔÚÖ´ÐеÄʱºò£¬ÊÇÓÉIISµ÷ÓóÌÐòÒýÇ ......
ÏÖÔÚÖ÷Á÷µÄÍøÕ¾¿ª·¢ÓïÑÔÎÞÍâºõasp¡¢php¡¢asp.net¡¢jspµÈ¡£
ÍøÒ³´Ó¿ªÊ¼¼òµ¥µÄhmtlµ½¸´ÔӵķþÎñÓïÑÔ£¬×ß¹ýÁË10¶à¸öÄêÍ·£¬¸÷ÖÖ¼¼Êõ²ã³ö²»Çµ¥¸öµÄÖ÷Á÷¼¼ÊõÒ²ÔÚ²»¶Ï·Ðµİ汾£¬ÏÖÔÚ·ÖÎöϸ÷ÖÖÓïÑÔµÄÇø±ð¡¢ÓÅÊÆ¡¢ÁÓÊÆ¡¢¿ª·¢×¢ÒâÊÂÏ
HTML:µ±È»ÕâÊÇÍøÒ³×î»ù±¾µÄÓïÑÔ,ÿһ¸ö·þÎñÆ÷ÓïÑÔ¶¼ÐèÒªËüµÄÖ§³Ö,Ҫѧϰ,Õâ¸ö¿Ï¶¨ÊÇ¿ªÊ¼,²»ËµÁË.
Ö÷Á÷ÍøÕ¾¿ª·¢ÓïÑÔÖ®ASP:ASPÊÇ΢Èí£¨Microsoft£©Ëù¿ª·¢µÄÒ»ÖÖºǫ́½Å±¾ÓïÑÔ£¬ËüµÄÓï·¨ºÍVisual BASICÀàËÆ£¬¿ÉÒÔÏñSSI£¨Server Side Include£©ÄÇÑù°Ñºǫ́½Å±¾´úÂëÄÚǶµ½HTMLÒ³ÃæÖС£ËäÈ»ASP¼òµ¥Ò×Ó㬵«ÊÇËü×ÔÉí´æÔÚ×ÅÐí¶àȱÏÝ£¬×îÖØÒªµÄ¾ÍÊǰ²È«ÐÔÎÊÌ⡣ĿǰÔÚ΢ÈíµÄ .net Õ½ÂÔÖÐÐÂÍÆ³öµÄASP.net ½è¼øÁËJava¼¼ÊõµÄÓŵ㣬ʹÓÃC Sharp (C#) ÓïÑÔ×÷ΪASP.netµÄÍÆ¼öÓïÑÔ£¬Í¬Ê±¸Ä½øÁËÒÔǰASPµÄ°²È«ÐÔ²îµÈȱµã¡£µ«ÊÇ£¬Ê¹ÓÃASP/ASP.netÈÔÓÐÒ»¶¨µÄ¾ÖÏÞÐÔ£¬ÒòΪ´ÓijÖֽǶÈÀ´ËµËüÃÇÖ»ÄÜÔÚ΢ÈíµÄ Windows NT/2000/XP + IISµÄ·þÎñÆ÷ƽ̨ÉÏÁ¼ºÃÔËÐУ¨ËäÈ»ÏñChilliSoftÌṩÁËÔÚUNIX/LinuxÉÏÔËÐÐASPµÄ½â¾ö·½°¸£¬µ«ÊÇĿǰASPÔÚUNIX/LinuxÉϵÄÓ¦ÓÿÉÒÔ˵¼¸ºõΪ0£©¡£ËùÒÔÆ½Ì¨µÄ¾ÖÏÞÐÔºÍASP×ÔÉíµÄ°²È«ÐÔÏÞÖÆÁËASPµÄ¹ã·ºÓ¦Óá£
ASPÔÚÖ´ÐеÄʱºò£¬ÊÇÓÉIISµ÷ÓóÌÐòÒýÇ ......
<bgsound src="wen.mid" loop="0">
<% dim weh
If Time >=#1:00:00 AM# And Time < #6:00:00 PM# Then
weh = "<bgsound src="1.mid" loop="0">"
Else If Time >#6:00:00 AM# And Time < #9:00:00 PM#
weh = "<bgsound src="2.mid" loop="0">"
Else If Time >#9:00:00 AM# And Time < #12:00:00 PM#
weh = "<bgsound src="3.mid" loop="0">"
Else If Time >#12:00:00 AM# And Time < #14:00:00 PM#
weh = "<bgsound src="4.mid" loop="0">"
Else If Time >=#14:00:00 AM# And Time < #17:00:00 PM#
weh = "<bgsound src="4.mid" loop="0">"
Else If Time >=#17:00:00 AM# And Time < #19:00:00 PM#
weh = "<bgsound src="5.mid" loop="0">"
Else If Time >=#19:00:00 AM# And Time < #24:00:00 PM#
weh = "<bgsound src="6.mid" loop="0">" ......
Abs £¨ÊýÖµ£©
¾ø¶ÔÖµ¡£Ò»¸öÊý×ֵľø¶ÔÖµÊÇËüµÄÕýÖµ¡£¿Õ×Ö·û´® (null) µÄ¾ø¶ÔÖµ£¬Ò²ÊÇ¿Õ×Ö·û´®¡£Î´³õʼ»¯µÄ±äÊý£¬Æä¾ø¶ÔΪ 0
Àý×Ó£ºABS(-2000)
½á¹û£º2000
Array £¨ÒÔ¶ºµã·Ö¸ôµÄÊý×éÔªËØ£©
Array º¯Êý´«»ØÊý×éÔªËØµÄÖµ¡£
Àý×Ó£º
A=Array(1,2,3)
B=A(2)
½á¹û£º 2
˵Ã÷£º±äÁ¿£ÂΪ£ÁÊý×éµÄµÚ¶þ¸öÔªËØµÄÖµ¡£
£Ásc £¨×Ö·û´®£©
½«×Ö·û´®µÄµÚÒ»×Öĸת»»³É ANSI £¨ÃÀ¹ú¹ú¼Ò±ê×¼·ûºÅ£©×ÖÂë¡£
Àý×Ó£º£Ásc£¨£¢Internet£¢£©
½á¹û£º73
˵Ã÷£ºÏÔʾµÚÒ»×Öĸ I µÄ ANSI ×ÖÂë¡£
CBool£¨±í´ïʽ£©
ת»»³É²¼¶ûÂß¼Öµ±äÁ¿ÐÍ̬£¨£Ôrue »ò£Æalse £©
Àý×Ó£ºCBool£¨1+2£©
½á¹û£ºTrue
CDate £¨ÈÕÆÚ±í´ïʽ£©
»»³ÉÈÕÆÚ±äÁ¿ÐÍ̬¡£¿ÉÏÈʹÓà IsDate º¯ÊýÅжÏÊÇ·ñ¿ÉÒÔת»»³ÉÈÕ ÆÚ¡£
Àý×Ó£º CDate (now( )+2)
½á¹û£º2000/5/28 10:30:59
CDbl£¨±í´ïʽ£©
ת»»³ÉDOUBLE±äÁ¿ÐÍ̬¡£
¡¡
Chr £¨ ANSI ×ÖÂ룩
½«ASCII ×ÖÂëת»»³É×Ö·û¡£
Àý×Ó£º Chr £¨ 72 £©
½á¹û£º H
CInt £¨±í´ïʽ£©
ת»»³ÉÕûÊý±äÁ¿ÐÍ̬¡£
Àý×Ó£º CInt ("3.12")
½á¹û£º 3
CLng £¨±í´ïʽ£©
ת»»³ÉLONG ±äÁ¿ÐÍ̬¡£
¡¡
CSng £¨±í´ïʽ£©
ת»»³ÉSINGLE ±äÁ¿ÐÍ̬¡£
¡¡
CStr £¨±í´ïʽ£©
ת»»³É×Ö·û´®±äÁ ......
aspÁ¬½ÓSQL2000µÄÓï¾ä:
set conn=Server.CreateObject("adodb.connection")
conn.open "Driver={SQL SERVER};server=(local);database=Mydata;UID=sa;PWD=123;"
aspÁ¬½ÓSQL2005µÄÓï¾ä:
set conn=Server.CreateObject("adodb.connection")
path="Provider=SQLNCLI;Server=(local)\SQL2005;uid=Gaojie;pwd=123;database=Mydata2005"
conn.open path
DB_ServerName ="(local)\SQLEXPRESS" 'Êý¾Ý¿âÃû³Æ(IP+ʵÀýÃû)
DB_UserName = "sa" 'SQLÓû§Ãû
DB_PassWord = "12F352f" 'SQLÓû§ÃÜÂë
DB_DateBase = "TFSCM" 'Êý¾Ý¿âÃû
DB_Provider = "SQLNCLI" 'Çý¶¯³ÌÐò
DB_ConnStr = "Provider="&DB_Provider&"; UID="&DB_UserName&"; Pwd="&DB_PassWord&"; database="&DB_DateBase&"; Server="&DB_ServerName&";"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open DB_ConnStr
http://blog.csdn.net/wyaspnet/archive/2009/08/19/4462605.aspx
Server=.¿ÉÒÔ²âÊÔÁ¬½Ó³ ......
aspÁ¬½ÓSQL2000µÄÓï¾ä:
set conn=Server.CreateObject("adodb.connection")
conn.open "Driver={SQL SERVER};server=(local);database=Mydata;UID=sa;PWD=123;"
aspÁ¬½ÓSQL2005µÄÓï¾ä:
set conn=Server.CreateObject("adodb.connection")
path="Provider=SQLNCLI;Server=(local)\SQL2005;uid=Gaojie;pwd=123;database=Mydata2005"
conn.open path
DB_ServerName ="(local)\SQLEXPRESS" 'Êý¾Ý¿âÃû³Æ(IP+ʵÀýÃû)
DB_UserName = "sa" 'SQLÓû§Ãû
DB_PassWord = "12F352f" 'SQLÓû§ÃÜÂë
DB_DateBase = "TFSCM" 'Êý¾Ý¿âÃû
DB_Provider = "SQLNCLI" 'Çý¶¯³ÌÐò
DB_ConnStr = "Provider="&DB_Provider&"; UID="&DB_UserName&"; Pwd="&DB_PassWord&"; database="&DB_DateBase&"; Server="&DB_ServerName&";"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open DB_ConnStr
http://blog.csdn.net/wyaspnet/archive/2009/08/19/4462605.aspx
Server=.¿ÉÒÔ²âÊÔÁ¬½Ó³ ......
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Drawing;
namespace WebApplication2
{
[DefaultProperty("Text")]
[ToolboxData("<{0}:VerificationCode runat=server></{0}:VerificationCode>")]
public class VerificationCode : WebControl,IHttpHandler
{
private String _code="Hello";
public String Code
{
get
{
return _code;
}
set
{
_code = value;
}
}
public VerificationCode() : base(HtmlTextWriterTag.Img) { }
protected override void AddAttributesToRender(HtmlTextWriter writer)
{
base.AddAttributesToRender(writer);
writer.AddAttribute("onclick", "this.src=this.src+'?'");
......
ÉÏ´Î×öÁ˸öÏîÄ¿£¬Éæ¼°µ½Êý¾Ý¿âµÄ»¹ÔºÍ»Ö¸´£¬µ½ÍøÉÏÕÒÁËһϣ¬ÊÇÀûÓÃSQLDMOʵÏֵģ¬Ö»ÒªÌí¼ÓSQLDMOÒýÓþͺÃÁË£¬
È»ºóÀûÓÃϱߵÄÀàµÄ·½·¨¾Í¿ÉÒÔʵÏÖÁË¡£
ÎÒ°ÑÔ×÷ÕßµÄÀàÀ©³äÁËһϣ¬¿ÉÒÔ×Ô¶¯Ê¶±ðweb.configÀï µÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬¿ÉÒÔͨ¹ý±äÁ¿ÉèÖû¹Ô»Ö¸´µÄÐÅÏ¢¡£
ÐèҪעÒâµÄʱ»¹Ô£¬»¹ÔµÄʱºòÎÊÌâ×î´óÁË£¬ÓбðµÄÓû§Ê¹ÓÃÊý¾Ý¿âµÄʱºòÎÞ·¨»¹Ô£¬½â¾ö°ì·¨¾ÍÊÇÔÚMASTERÊý¾Ý¿âÖÐ
Ìí¼ÓÒ»¸ö´æ´¢¹ý³Ì£º
create proc killspid (@dbname varchar(20))
as
begin
declare @sql nvarchar(500)
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
exec('kill '+@spid)
fetch next from getspid into @spid
end
close getspid
deallocate getspid
end
GO
ÔÚ»¹Ô֮ǰÏÈÖ´ÐÐÕâ¸ö´æ´¢¹ý³Ì£¬ÐèÒª´«µÝdbname£¬¾ÍÊÇÄãµÄÊý¾Ý¿âµÄÃû×Ö¡£Ï±ßÊÇÀàµÄÔ´úÂ룺£¨web.configÀïµÄÊý
¾Ý¿âÁ¬½Ó×Ö·û´®ÊÇconstr£©
using System;
using System.Conf ......
ÉÏ´Î×öÁ˸öÏîÄ¿£¬Éæ¼°µ½Êý¾Ý¿âµÄ»¹ÔºÍ»Ö¸´£¬µ½ÍøÉÏÕÒÁËһϣ¬ÊÇÀûÓÃSQLDMOʵÏֵģ¬Ö»ÒªÌí¼ÓSQLDMOÒýÓþͺÃÁË£¬
È»ºóÀûÓÃϱߵÄÀàµÄ·½·¨¾Í¿ÉÒÔʵÏÖÁË¡£
ÎÒ°ÑÔ×÷ÕßµÄÀàÀ©³äÁËһϣ¬¿ÉÒÔ×Ô¶¯Ê¶±ðweb.configÀï µÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬¿ÉÒÔͨ¹ý±äÁ¿ÉèÖû¹Ô»Ö¸´µÄÐÅÏ¢¡£
ÐèҪעÒâµÄʱ»¹Ô£¬»¹ÔµÄʱºòÎÊÌâ×î´óÁË£¬ÓбðµÄÓû§Ê¹ÓÃÊý¾Ý¿âµÄʱºòÎÞ·¨»¹Ô£¬½â¾ö°ì·¨¾ÍÊÇÔÚMASTERÊý¾Ý¿âÖÐ
Ìí¼ÓÒ»¸ö´æ´¢¹ý³Ì£º
create proc killspid (@dbname varchar(20))
as
begin
declare @sql nvarchar(500)
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
exec('kill '+@spid)
fetch next from getspid into @spid
end
close getspid
deallocate getspid
end
GO
ÔÚ»¹Ô֮ǰÏÈÖ´ÐÐÕâ¸ö´æ´¢¹ý³Ì£¬ÐèÒª´«µÝdbname£¬¾ÍÊÇÄãµÄÊý¾Ý¿âµÄÃû×Ö¡£Ï±ßÊÇÀàµÄÔ´úÂ룺£¨web.configÀïµÄÊý
¾Ý¿âÁ¬½Ó×Ö·û´®ÊÇconstr£©
using System;
using System.Conf ......