视图只支持INSTEAD OF 触发器 CREATE TRIGGER abcadd ON abc INSTEAD OF INSERT AS INSERT INTO abc1 (a1, a2, a3) SELECT ins.a1, ins.a2, ins.a3 FROM inserted ins
CREATE TRIGGER abcadd ON abc INSTEAD OF INSERT AS INSERT INTO abc SELECT * FROM inserted ins INSERT INTO abc1 SELECT * FROM inserted ins
既然数据太多,再建触发器不是更加增加负担?happydreamer(小黑-不懂的太多) 的触发器是正确的,最好改为:CREATE TRIGGER abcadd ON abc INSTEAD OF INSERT AS INSERT INTO TABabc(...) --这里TABabc是视图abc的基表,如果多个基表要拆成多个insert 语句 SELECT ... FROM inserted insINSERT INTO abc1 (a1, a2, a3) SELECT ins.a1, ins.a2, ins.a3 FROM inserted ins
不过你可以在基本表上建触发器的
CREATE TRIGGER abcadd
ON abc
INSTEAD OF INSERT
AS
INSERT INTO abc1
(a1,
a2,
a3)
SELECT ins.a1,
ins.a2,
ins.a3
FROM inserted ins
ON abc
INSTEAD OF INSERT
AS INSERT INTO abc
SELECT * FROM inserted ins INSERT INTO abc1
SELECT * FROM inserted ins
ON abc
INSTEAD OF INSERT
AS INSERT INTO TABabc(...) --这里TABabc是视图abc的基表,如果多个基表要拆成多个insert 语句
SELECT ... FROM inserted insINSERT INTO abc1
(a1,
a2,
a3)
SELECT ins.a1,
ins.a2,
ins.a3
FROM inserted ins