TR_RELATIONSHIP_TASYNC_D

Definition

Copy


        CREATE trigger TR_RELATIONSHIP_TASYNC_D on dbo.RELATIONSHIP after delete not for replication
        as begin
            if dbo.UFN_B2T_CONTEXTISSYNC() = 1
                delete from dbo.TA_RELATIONSHIP
                where ID in(select ID from DELETED)
            else
            begin
                merge dbo.TA_RELATIONSHIP t
                using (select ID from DELETED) d
                on (d.ID = t.ID)
                when matched and t.ACTIONCODE = 1 then
                    delete
                when matched then
                update set ACTIONCODE = 3;
            end
        end