這樣的觸發器怎麽寫?

[编译失败]

一個主表a，一個明細表b
我想在a的某個id的記錄被刪除後，b中和a中id相同的記錄都被刪除.

[txlicenhe]

Create trigger 触发器名 on 表a
For Delete
As
Delete 表b where id in (select id from deleted)

[yujohny]

CREATE TRIGGER test on a
for delete
as
delete b where id in (select id from deleted)

[yczzg]

Create trigger 触发器名 on 表a
For Delete
As
Delete from 表b where id=deleted.id

[yujohny]

最好你设置级联删除了，这样这个触发器就可以免了

[SE1]

CREATE TRIGGER dela
ON a
FOR DELETE
AS
BEGIN
delete b
from b,deleted
where b.id=deleted.id
END

[编译失败]

什麽叫級聯刪除？怎麽設？

[yujohny]

你两个表建了关系图没有？

[yujohny]

关系图中的关系连接线，右击——》属性——》选择级联删除相关记录