触发器不用在程序中调用的,你用的是MS SQL的话,当你在删除A表的时候把数据插入到A表.但是你这样的话,不要触发器就可以完成的. insert into t2 select * from t1 where id = XXX delete from t1 where id = XXX
CREATE OR REPLACE TRIGGER tri_tableA_delete AFTER INSERT ON B DECLARE BEGIN delete from A where A.PRIMARYKEY=:new.primarykey; END; 试试看 调用好像不需要吧 ,触发器为什么要调用呢
insert into t2
select * from t1 where id = XXX
delete from t1 where id = XXX
AFTER INSERT ON B
DECLARE
BEGIN
delete from A where A.PRIMARYKEY=:new.primarykey;
END;
试试看
调用好像不需要吧 ,触发器为什么要调用呢