A question about triggers

白痴的傻瓜

A table fields
id
num

Table B fields
id
num

Table association a.id = b.id


problem:

How can the num of table a be changed when the num of table b is modified? Make a.num = b.num

我是杀人狂

create trigger aa on b
for update
as
if update (num)
begin
update a set a.num = b.num from b b, inserted where a.id = b.id
end

恶魔右指

The landlord, if the two tables do not have a primary key connection relationship, it cannot be achieved, and it is not practical.

白痴的傻瓜

Table association a.id = b.id