create trigger up_Tb on Ta
for update
asupdate TB
set Fb2=(select Fa1 from inserted)
where Ta.P1=(select Fb1 from inserted)
for update
asupdate TB
set Fb2=(select Fa1 from inserted)
where Ta.P1=(select Fb1 from inserted)
ON ta
FOR INSERT, UPDATE
AS
If UPDATE(fa1)
BEGIN
update tb
set fb2=inserted.fa1
from tb inner join inserted
on tb.fb1=inserted.p1
END
GO
for update
as
update Tb set Tb.Fb2=a.Fa1 from inserted a where Tb.Fb1=a.Pl
as
begin
update tb set tb.Fb2=inserted.Fa1 from inserted where inserted.P1=Tb.Fb1end
for update
as
update tb fb2=AA.fa1 from inserted AA where AA.p1=tb.fb1