create or replace trigger chufaqi
after insert on ry_jfxx
for each rowbegin
declare @ls_xh; select @ls_xh=学号 from ry_jfxx then
insert into ry_jfxx_sbsh(jfxh) values(:ls_xh)
end chufaqi;
after insert on ry_jfxx
for each rowbegin
declare @ls_xh; select @ls_xh=学号 from ry_jfxx then
insert into ry_jfxx_sbsh(jfxh) values(:ls_xh)
end chufaqi;
具体需求是什么?
begin
insert into ry_jfxx_sbsh(jfxh) values(:new.ls_xh);
end chufaqi;
-- 你是在什么数据库软件下测试?SQL Server?Oracle?DB2?or My SQL?
create or replace trigger chufaqi
after insert on ry_jfxx
for each row
begin
insert into ry_jfxx_sbsh(jfxh) values(:new.学号) ;
end chufaqi;