你不介意的话 可以用触发器create trigger on a after delete as delete b where id=(select id from deleted) DELETE A WHERE ID='C'--A表删除后 自动删除C
如果你用的是 SQL2005 你在A表上新建一个存储过程 create trigger del_A on A for delete as begin delete from A where id='C' if not exits(select * from A where id='C') begin delete from B where id='C' end end go
create trigger del on A for delete as declare @id (A表里的id类型) select @id=id from deleted if @id='C' begin delete from B where id='C' end go这里是在A表上建立的触发器 如果删除了A标中id值为C的记录 同时B表中也会删除id值为C的记录
DELETE B WHERE ID='C'
after delete
as
delete b
where id=(select id from deleted)
DELETE A WHERE ID='C'--A表删除后 自动删除C
create trigger del_A
on A
for delete
as
begin
delete from A where id='C'
if not exits(select * from A where id='C')
begin
delete from B where id='C'
end
end
go
on A
for delete
as
declare @id (A表里的id类型)
select @id=id from deleted
if @id='C'
begin
delete from B where id='C'
end
go这里是在A表上建立的触发器 如果删除了A标中id值为C的记录 同时B表中也会删除id值为C的记录