;
with
f
as
(
select
*
from
tab
where
id=1
union
all
a.*
a
inner
join
b
on
a.pid=b.id
)
SQLServer查询所有子节点
原文：http://www.cnblogs.com/johnblogs/p/6803274.html
