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