--
Disable
the
trigger.仅用触发器
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
GO
--
INSERT
GO
--
ALTER