至高吴上(Alfa.wu)

摘要： drop proc proc_insertgocreate proc proc_insert (@tablename varchar(256))asbeginset nocount ondeclare @sqlstr varchar(4000)declare @sqlstr1 varchar(4000)declare @sqlstr2 varchar(4000)select @sqlstr='select ''insert '+@tablenameselect @sqlstr1=''select @sqlstr2=' ('sele 阅读全文

摘要： ALTER TABLE [stores] NOCHECK CONSTRAINT All --暂停约束ALTER TABLE [stores] DISABLE TRIGGER ALL --暂停触发器--------执行自己的操作--------ALTER TABLE [stores] ENABLE TRIGGER ALL --恢复触发器ALTER TABLE [stores] CHECK CONSTRAINT All --恢复约束select * from sysobjects where xtype='TR'select * from sysobjects where xtyp 阅读全文