with my1 as(select * from NewsClass where id = @did
union all select NewsClass.* from my1, NewsClass where my1.id = NewsClass.parentID
)
delete from NewsClass where exists (select id from my1 where my1.id = NewsClass.id)
union all select NewsClass.* from my1, NewsClass where my1.id = NewsClass.parentID
)
delete from NewsClass where exists (select id from my1 where my1.id = NewsClass.id)

被折叠的 条评论
为什么被折叠?



