摘要：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 阅读全文