suppose:
mytab_a(a1,b1)
mytab_b(a2,b2)create trigger on mytab_a
for insert
as
insert into mytab_b(b2) select b1 from inserted
mytab_a(a1,b1)
mytab_b(a2,b2)create trigger on mytab_a
for insert
as
insert into mytab_b(b2) select b1 from inserted
for insert
as
insert into mytab_b select 某字段 from inserted
go