触发器问题，急！！

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)