SQL Server with a recursive delete

A common table expression (CTE) is provided in Server 2005, using a CTE to make the SQL statement maintainable, while the CTE is much more efficient than a table variable.

Stored Procedure methods:

1Create proc Up_delete_nclass
2@ didInt
3As
4With My1 as (SELECT * from news_class where id = @ did
5UNION ALL select news_class.* from My1, news_class where my1.id = News_class.parentid
6)
7Delete from News_class where exists (select ID from my1 where my1.id = news_class.id)
8Go
9
TenEXEC Up_delete_nclass -

Non-Stored procedure method:

1With My1 as (SELECT * from AAA WHERE id =1
2UNION ALL select Aaa.* from My1, aaa where my1.id = Aaa.pid
3)
4Delete from the AAA where exists (select ID from my1 where my1.id = aaa.id)