怎样进行多表同时操作啊SQL

[zzs1980]

假设我有3个表 aaa, bbb, ccc

分别有字段(编号(自动编号）,姓名) , (编号,性别) , (编号,年龄)

怎样才能进行同时添加,更新,删除??

[LouisXIV]

用触发器即可

[LouisXIV]

不过要注意循环调用问题

[十一月猪]

1. trigger
create trigger aaa_d
on aaa
for delete
as
begin
delete from bbb where id in (select id from deleted)
delete from ccc where id in (select id from deleted)
end

create trigger aaa_u
on aaa
for delete
as
begin
update bbb
set id = (select id from inserted)
where id = (select id from deleted)
update cc
set id = (select id from inserted)
where id = (select id from deleted)
end

2 级联 foreignkey

[十一月猪]

insert 的时候
不知道楼主想怎么样往另外两张
表里面插入！