A库中建insert trigger
use A
go
create trigger trig_inAC
on C
for insert
as
begin
insert into B..C select * from inserted
end
go
B库中建update trigger
use B
go
create trigger trig_upBC
on C
for update
as
if update(name)
begin
update A..C set name=inserted.name from A..C,inserted, deleted where deleted.name=A..C.name
end
go