先建立与oracle的链接服务器.
create trigger tri_test
 on insert,update
for 表
as
   if exists(select * from deleted)
   begin
       --update command
   end
   else
   begin
       --insert command
   end
go


--2005
insert into tb
 output inserted.xx,inserted.xxx into @表变量
select * from xx

insert into oracle...表
 select * from @表变量