时间：2021-07-01 10:21:17 帮助过：41人阅读
;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