触发器可以实现的,但不知道你A,B,C表结构,不知道你的同时更新是指同时新增,修改,删除? 下例仅新增: create table a(aid varchar(10)) create table b(bid varchar(10)) create table c(cid varchar(10))create trigger a_tg on a for insert as insert into b select * from inserted insert into c select * from inserted insert into a values('2001')select * from a select * from b select * from c
下例仅新增:
create table a(aid varchar(10))
create table b(bid varchar(10))
create table c(cid varchar(10))create trigger a_tg on a
for insert
as
insert into b select * from inserted
insert into c select * from inserted
insert into a values('2001')select * from a
select * from b
select * from c