??Asp.net???????sqlserver?????
???????????? ???????[ 2014/5/8 11:09:31 ] ??????????????
??????????????????漰????????????????????????????£???????SQLDMO??????????SQLDMO???ú????????????±??????????????????
???????????????????????£???????????web.config?? ?????????????????????????????????????????????
??????????????????????????????????б??????????????????????????????????MASTER??????????????洢?????
createprockillspid(@dbnamevarchar(20))
as
begin
declare@sqlnvarchar(500)
declare@spidint
set@sql='declaregetspidcursorfor
selectspidfromsysprocesseswheredbid=db_id('''+@dbname+''')'
exec(@sql)
opengetspid
fetchnextfromgetspidinto@spid
while@@fetch_status<>-1
begin
exec('kill'+@spid)
fetchnextfromgetspidinto@spid
end
closegetspid
deallocategetspid
end
GO
|
???????????????????洢????????????dbname???????????????????±?????????????web.config???????????????????constr??
using System;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
namespace web.base_class
{
/// <summary>
/// </summary>
public class DbOper
{
private string server;
private string uid;
private string pwd;
private string database;
private string conn;
/// <summary>
/// DbOper????????
/// </summary>
|
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11