TR_ADDRESSVALIDATIONUPDATE_T2BINSERTUPDATE (Trigger)

                
                    create trigger TR_ADDRESSVALIDATIONUPDATE_T2BINSERTUPDATE on dbo.ADDRESSVALIDATIONUPDATE after insert, update not for replication
                    as begin
                    if dbo.UFN_B2T_CONTEXTISSYNC() = 0
                        -- force re-sync of the parent row

                        update dbo.TA_ADDRESS
                        set ACTIONCODE = case when ACTIONCODE=1 then 1 else 2 end
                        where ID in(select ID from INSERTED)
                    end