TR_RELATIONSHIP_TASYNC_U

Definition

Copy


        CREATE trigger TR_RELATIONSHIP_TASYNC_U on dbo.RELATIONSHIP after update not for replication
        as begin
            if dbo.UFN_B2T_CONTEXTISSYNC() = 0
            begin
                update t
                set ACTIONCODE = case when ACTIONCODE=1 then 1 else 2 end
                from dbo.TA_RELATIONSHIP t
                inner join INSERTED i on i.ID = t.ID
         end
        end