TR_ADDRESS_TASYNC_D (Trigger)

            
             create trigger TR_ADDRESS_TASYNC_D on dbo.ADDRESS after delete not for replication
             as begin
                if dbo.UFN_B2T_CONTEXTISSYNC() = 1
                  delete from dbo.TA_ADDRESS
                  where ID in(select ID from DELETED)
                else
                begin
                  merge dbo.TA_ADDRESS 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