触发器问题,急!!
T_Article表里的记录可能会有多层,比如
ArticleID parentarticleid
233 Re:第5篇 3 109 109
234 Re:Re:第5篇 3 233 109
235 Re:Re:Re:第5篇 3 234 109
可能会有更多层,我使用delete触发器,删除的时候能实现把相关的记录都删除吗?
我的触发器是这样写的:
CREATE TRIGGER [del_article] ON [dbo].[T_Article]
FOR DELETE
AS
delete from T_AttachedFile where ArticleID in (select ArticleID from deleted)
delete from T_Assess where ArticleID in (select ArticleID from deleted)
delete from T_Article where ParentArticleID in (select ArticleID from deleted)
delete from T_Article where RootArticleID in (select ArticleID from deleted)