摘要：using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.Data;public class DBHelperSQL{ /// <summary> /// 数据库连接字符串 /// </summary> private static string _conStr = System.Configuration.ConfigurationManager.ConnectionStrings[ 阅读全文

摘要：use masterdeclare @dbname sysname set @dbname='AAA' --这个是要删除的数据库库名 IF EXISTS (SELECT * FROM SYSDATABASES WHERE name=@dbname) BEGIN declare @s nvarchar(1000) declare tb cursor local for select s='kill '+cast(spid as varchar) from master..sysprocesses where dbid=db_id(@dbname) open tb 阅读全文

摘要：--用户表 触发器 (主要用于同步班级人数)IF EXISTS (SELECT name FROM sysobjects WHERE name = 'Trig_UserInfo' and xtype='TR')DROP TRIGGER Trig_UserInfoGOCREATE TRIGGER Trig_UserInfo ON UserInfoFOR UPDATE , INSERT , DELETEAS IF UPDATE(ClassId) --添加人员 或者 改变了班级 BEGIN --原班级人数 -1 UPDATE ClassInfo SET Student 阅读全文

摘要：EXEC sp_dboption 'menuDB', 'autoshrink', 'TRUE' 阅读全文

摘要：DBCC SHRINKFILE(库名_log,0)DUMP TRANSACTION 库名 WITH NO_LOG 阅读全文

摘要：--查询服务中的数据库和MDF,LOG文件的所在位置use masterselect a.*,b.* from sys.sysdatabases a inner join sys.sysaltfiles b on a.dbid = b.dbid--查看服务器中各数据库状态exec sp_helpdb 阅读全文