SQL Server与Oracle的数据同步-性能调优-Oracle频道-中国IT实验室

         --说明:modiid等于1为insert,2为delete,3为update

        create trigger trg_PUBLISHLASTREC_insert on PUBLISHLASTREC for insert

        as

        insert into dbo.PublishLastRec_SQL(modiid,SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,IsExec)

        select '1',SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,'0' from inserted

        create trigger trg_PUBLISHLASTREC_update on PUBLISHLASTREC for update

        as

        insert into dbo.PublishLastRec_SQL(modiid,SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,IsExec)

        select '3',SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,'0' from inserted

        create trigger trg_PUBLISHLASTREC_delete on PUBLISHLASTREC for delete

        as

        insert into dbo.PublishLastRec_SQL(modiid,SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,IsExec)

        select '2',SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,'0' from deleted

--------------------next---------------------