[MS SQL]禁用触发器
--禁用触发器declare @Tbl char(20)declare @Trig char(20)declare @SQL char(200)DECLARE c_Trig CURSOR FOR ---取所有触发器select object_name(parent_obj) as TblName, as TrigNamefrom sysobjectswhere type='TR'and (status & 2048=2048) --状态为“启用”OPEN c_TrigFETCH NEXT FROM c_Trig INTO @Tbl, @TrigWHILE @@FETCH_STATUS = 0BEGINset @Sql='alter table ' + @Tbl + ' disable trigger ' + @Trigexec(@sql) --因SQL Server中表名不能使用变量，故要使用SQL语句FETCH NEXT FROM c_Trig INTO @Tbl, @TrigENDCLOSE c_TrigDEALLOCATE c_Trig
页:
[1]