TR_PDACCOUNTSYSTEM_UPD

Definition

Copy


        CREATE trigger dbo.TR_PDACCOUNTSYSTEM_UPD on dbo.PDACCOUNTSYSTEM
        with execute as owner
        for update
        as
        begin
        set nocount on
        if update(DEFAULTGLACCOUNTID)
          delete PDACCOUNTLOOKUPCACHE 
          from dbo.PDACCOUNTLOOKUPCACHE inner join inserted on PDACCOUNTLOOKUPCACHE.PDACCOUNTSYSTEMID = inserted.ID
        end