存储过程
我是新手今天头让我试着写一个存储过程
实现定时运行使A表数据与B表中的数据比较
如果B表新增记录对应把新增记录添入A表
[61 byte] By [msdn] at [2007-8-14 15:34:25] 
# 1 Re: 存储过程
create trigger b_tri
before insert or update or delete on b
for each row
begin
if inserting then
insert into a (col1,col2,...) values(:new.col1,:new.col2,...);
elsif updating then
update a set col=:new.col where id=:old.id;
elsif deleting then
delete from a where id=:old.id;
end if;
end;
/
beckhambobo at 2004-7-10 18:28:33 >