关闭触发器: ALTER TABLE tablename DISABLE TRIGGER trigname 开启触发器: ALTER TABLE tablename ENABLE TRIGGER trigname
ALTER TABLE trig_example DISABLE TRIGGER trig1 GO -- Attempt an insert that would normally violate the trigger INSERT INTO trig_example VALUES (2,"Chuck Jones",100001) GO -- Re-enable the trigger. ALTER TABLE trig_example ENABLE TRIGGER trig1 楼主看一下联机帮助也写得很详细了 在帮助输入alter table
ALTER TABLE tablename DISABLE TRIGGER trigname
开启触发器:
ALTER TABLE tablename ENABLE TRIGGER trigname
GO
-- Attempt an insert that would normally violate the trigger
INSERT INTO trig_example VALUES (2,"Chuck Jones",100001)
GO
-- Re-enable the trigger.
ALTER TABLE trig_example ENABLE TRIGGER trig1
楼主看一下联机帮助也写得很详细了
在帮助输入alter table