关简单触发器问题求助！

[jakedai]

哪位能帮我写一下关于我要删除其中一张表中的记录信息时，能够将关联的数据信息全部去除？

[Rewiah]

create trigger tr_a_delete
on a
for delete
as

delete b
from deleted
where b.aid=deleted.id

delete c
from deleted
where c.aid=deleted.id

...

delete N
from deleted
where N.aid=deleted.id

go

[pengdali]

create trigger tr_a_delete on 你的表
for delete
as
delete 另一个有关联的表 where 编号 in (select 编号 from deleted)

[流星尔]

直接在数据库关系图中新建一个关系，关系属性级联删除

[jakedai]

呵呵！第一次学写这个，能不能介绍一下要哪可以下载有关于SQL　Server2000 方面操作的手