根据子节点查询所有父节点
WITH dept_parent AS
(
SELECT * FROM Ts_Dept WHERE DeptID='10016'
UNION ALL
SELECT Ts_Dept.* FROM dept_parent,Ts_Dept WHERE Ts_Dept.DeptID=dept_parent.parentid
)
SELECT * FROM dept_parent
根据父节点查询所有子节点
WITH Ts_Dept_children AS
(
SELECT * FROM Ts_Dept WHERE ParentId='10001'
UNION ALL
SELECT Ts_Dept.* FROM Ts_Dept_children,Ts_Dept WHERE Ts_Dept.ParentId=Ts_Dept_children.DeptID
)
SELECT * FROM Ts_Dept_children