sql server实现递归查询的方法示例

----------sql server 递归查询----------

--查找上级所有节点

withuCteas

(

  selecta.id,a.title,a.pidfromtree_table awhereid = 3--当前节点

  unionall

  selectk.id,k.title,k.pidfromtree_table k

  innerjoinuCte conc.pid = k.id

)

select*fromuCte;

--查找上级所有节点

withdCteas

(

  selecta.id,a.title,a.pidfromtree_table awhereid = 3--当前节点

  unionall

  selectk.id,k.title,k.pidfromtree_table k

  innerjoindCte conc.id = k.pid

)

select*fromdCte;