急求 触发器问题
0
其他回答(1)
0
在A表中创建触发
CREATE TRIGGER [TRIGGER NAME] ON [dbo].[l_p_images]
FOR INSERT, UPDATE, DELETE
AS
也可以在B表插入数据时,在程序中处理
0
create or replace trigger B_AFTER_ALL
after insert or update or delete on B
for each row
declare
strTableName varchar(32) := 'B';
strValues varchar(256);
strPrimaryKeys varchar(256);
begin
if UPDATING then
strValues :='xueji='||:new.xueji;
strPrimaryKeys := 'STUDENTNUM='||:new.STUDENTNUM;
update A set strValues where strPrimaryKeys;
end if;
exception
when others then null;
end B_AFTER_ALL;
/
