如:update触发器: create t.. for update for insert 临时表2 select * from deleted insert 临时表1 select * from inserted--其中临时表2 是变化前的值!
oracle的操做前触发器,在sql中只能用替代操作触发器来实现!如: CREATE TRIGGER 名 on 表1 INSTEAD OF INSERT AS BEGIN INSERT INTO 表2 SELECT name1,name1 FROM inserted END 插入数据时它不会对表1插入,它会插入表2!
create t..
for update
for
insert 临时表2 select * from deleted
insert 临时表1 select * from inserted--其中临时表2 是变化前的值!
CREATE TRIGGER 名 on 表1
INSTEAD OF INSERT
AS
BEGIN
INSERT INTO 表2
SELECT name1,name1
FROM inserted
END
插入数据时它不会对表1插入,它会插入表2!