CREATE TRIGGER trg_insPayroll
for INSERT ON hrshicb
begin
insert into Hrsscbd(Cbdwno,Cbdbak,Cbdare,Cbdtfe)
select icbwno,1,'1',1 from inserted
insert into EmployeeCModel(Employeeid,Appid)
select icbwno,2 from inserted
end目的:当对表hrshicb插入数据时,同时对Hrsscbd与EmployeeCModel表插入记录,所需的icbwno字段需取hrshicb表中的icbwno字段
for INSERT ON hrshicb
begin
insert into Hrsscbd(Cbdwno,Cbdbak,Cbdare,Cbdtfe)
select icbwno,1,'1',1 from inserted
insert into EmployeeCModel(Employeeid,Appid)
select icbwno,2 from inserted
end目的:当对表hrshicb插入数据时,同时对Hrsscbd与EmployeeCModel表插入记录,所需的icbwno字段需取hrshicb表中的icbwno字段
AFTER INSERT
ON hrshicb
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
insert into Hrsscbd(Cbdwno,Cbdbak,Cbdare,Cbdtfe)
select icbwno,1,'1',1 from new;
insert into EmployeeCModel(Employeeid,Appid)
select icbwno,2 from new;
END trg_insPayroll;
CREATE OR REPLACE TRIGGER trg_insPayroll
AFTER INSERT
ON hrshicb
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
insert into Hrsscbd(Cbdwno,Cbdbak,Cbdare,Cbdtfe)
values(:new.icbwno,1,'1',1 );
insert into EmployeeCModel(Employeeid,Appid)
values(:new.icbwno,2);
END trg_insPayroll;