如果用的2000,可以设置外键和级联删除,具体看2000的联机丛书。
如果是6.5或7.0,看以下触发器(假设A表的关键字段是Id):
create Trigger Trigger_A_Delete
on A
for delete
as
delete b
from b,deleted i
where i.Id=b.id
delete C
from C,deleted i
where i.Id=C.idgo
如果是6.5或7.0,看以下触发器(假设A表的关键字段是Id):
create Trigger Trigger_A_Delete
on A
for delete
as
delete b
from b,deleted i
where i.Id=b.id
delete C
from C,deleted i
where i.Id=C.idgo
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货