;with f as
(
select * from tab where id=1
union all
select a.* from tab as a inner join f as b on a.pid=b.id
)
select * from f
SQLServer查询所有子节点
标签：lin 递归 index with union where 节点 number nbsp
SQLServer查询所有子节点
用CTE递归