sql server實(shí)現(xiàn)遞歸查詢的方法示例

----------sql server 遞歸查詢----------
--查找上級(jí)所有節(jié)點(diǎn)
with uCte as
(
  select a.id,a.title,a.pid from tree_table a where id = 3--當(dāng)前節(jié)點(diǎn)
  union all
  select k.id,k.title,k.pid from tree_table k
  inner join uCte c on c.pid = k.id
)
select * from uCte;
--查找上級(jí)所有節(jié)點(diǎn)
with dCte as
(
  select a.id,a.title,a.pid from tree_table a where id = 3--當(dāng)前節(jié)點(diǎn)
  union all
  select k.id,k.title,k.pid from tree_table k
  inner join dCte c on c.id = k.pid
)
select * from dCte;