create trigger tr
on a
for update
as
begin
declare @a datetime,@b char(10)
select @a=date,@b=code from inserted
update b set date=@a,code=@b where id=(select id from inserted)
end
on a
for update
as
begin
declare @a datetime,@b char(10)
select @a=date,@b=code from inserted
update b set date=@a,code=@b where id=(select id from inserted)
end
for update as
begin
update b
set date=i.date, code=i.code
from b join inserted i on b.id=i.id
end
go