sql server 2005 的递归查询示例
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)
页:
[1]