----------sql server 遞歸查詢----------
--查找上級所有節點
with uCte as
(
  select a.id,a.title,a.pid from tree_table a where id = 3--當前節點
  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;
--查找上級所有節點
with dCte as
(
  select a.id,a.title,a.pid from tree_table a where id = 3--當前節點
  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;