触发器在增量同步数据的运用代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】触发器在增量同步数据的运用

作者:Dezai.CN / 发布于2013/2/2/ 805

触发器在增量同步数据的运用

if exists (select * from dbo.sysobjects where id = object_id(N'[risk].[TRG_GUARANTEE_R_IN_HG]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [risk].[TRG_GUARANTEE_R_IN_HG]
if exists (select * from dbo.sysobjects where id = object_id(N'[risk].[TRG_GUARANTEE_R_DEL_HG]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [risk].[TRG_GUARANTEE_R_DEL_HG]
CREATE TRIGGER TRG_GUARANTEE_R_IN_HG
ON GUARANTEE_R
FOR INSERT,UPDATE
AS
UPDATE A SET ARJ_MARK='M',CREATE_TIME=GETDATE(),USING_FLAG='0000000000'
    FROM LOG_ENTRY_INC2 A INNER JOIN INSERTED B ON  A.ENTRY_ID = B.ENTRY_ID
    INSERT INTO LOG_ENTRY_INC2(ENTRY_ID,ARJ_MARK,CREATE_TIME,USING_FLAG)
    SELECT ENTRY_ID,'M',GETDATE(),'0000000000'
    FROM INSERTED where ENTRY_ID NOT IN (SELECT ENTRY_ID FROM LOG_ENTRY_INC2)
CREATE TRIGGER TRG_GUARANTEE_R_DEL_HG
ON GUARANTEE_R
FOR DELETE
AS
UPDATE A SET ARJ_MARK='D',CREATE_TIME=GETDATE(),USING_FLAG='0000000000'
    FROM LOG_ENTRY_INC2 A INNER JOIN INSERTED B ON  A.ENTRY_ID = B.ENTRY_ID
INSERT INTO LOG_ENTRY_INC2(ENTRY_ID,ARJ_MARK,CREATE_TIME,USING_FLAG)
    SELECT ENTRY_ID,'D',GETDATE(),'0000000000'
    FROM DELETED  where ENTRY_ID NOT IN (SELECT ENTRY_ID FROM LOG_ENTRY_INC2)

试试其它关键字

　触发器　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)