如何删除指定的节点和所有子节点

[liushiying18]

1,如何删除指定的节点和所有子节点,
2,如何修改指定节点和所有子节点的abc字段内容

ID          GroupID     Name           abc
----------- ----------- ------------------------------
1           0           AD
2           0           ASD
3           1           aa
4           1           asdfasdfa
5           0           asdf
6           0           asdfasdf
7           0           asdfasdfasdf
8           6           a
9           6           a 
10          4           ASDF
11          7           a
12          7           a

(12 行受影响)

[--小F--]

;with f as 
(
select * from tb where id='xx'
union all
select a.* from tb as a inner join f as b on a.id=b.groupid
)

delete ftom tb as t where exists(select 1 from f where id=t.id)

[liushiying18]

运行有问题啊,还有问题2 怎么解决