sqlserver中屏蔽触发器的语句怎么写？
比如要屏蔽表A中触发器TR_A那么怎么写？
我记得好象是用alter语句写具体怎么写忘记了～
请各位大大帮忙写一个。
问题点数：20、回复次数：3Top
1 楼paoluo（一天到晚游泳的鱼）回复于 2006-05-04 16:22:48 得分 20
-- Disable the trigger.
ALTER TABLE A DISABLE TRIGGER TR_A
-- Re-enable the trigger.
ALTER TABLE A ENABLE TRIGGER TR_ATop
2 楼azsoft（Try my best）回复于 2006-05-04 16:24:07 得分 0
ALTER TRIGGER TR_A
ON A
--已被屏蔽
Top
3 楼azsoft（Try my best）回复于 2006-05-04 16:27:25 得分 0
ALTER TABLE table
{ [ ALTER COLUMN column_name
{ new_data_type [ ( precision [ , scale ] ) ]
[ COLLATE < collation_name > ]
[ NULL | NOT NULL ]
| {ADD | DROP } ROWGUIDCOL }
]
| ADD
{ [ < column_definition > ]
| column_name AS computed_column_expression
} [ ,...n ]
| [ WITH CHECK | WITH NOCHECK ] ADD
{ < table_constraint > } [ ,...n ]
| DROP
{ [ CONSTRAINT ] constraint_name
| COLUMN column } [ ,...n ]
| { CHECK | NOCHECK } CONSTRAINT
{ ALL | constraint_name [ ,...n ] }
| { ENABLE | DISABLE } TRIGGER --果真有这一个属性 哈哈!
{ ALL | trigger_name [ ,...n ] }
}Top
