USE
Northwind
go
select employeeid ,reportsto from employees;
-- 察看2的子节点,右边是左边的父节点
with myT as (
select employeeid ,reportsto from employees
),
myT2 as (
select * from myT where reportsto = 2
union all
select myT. * from myT2 inner join myT
on myT2.employeeid = myT.reportsto
)
select * from myT2
-- 解除递归100次的限制
option (maxrecursion 0 )
go
select employeeid ,reportsto from employees;
-- 察看2的子节点,右边是左边的父节点
with myT as (
select employeeid ,reportsto from employees
),
myT2 as (
select * from myT where reportsto = 2
union all
select myT. * from myT2 inner join myT
on myT2.employeeid = myT.reportsto
)
select * from myT2
-- 解除递归100次的限制
option (maxrecursion 0 )