WITH cte AS ( SELECT Id,Pid,DeptName,0 AS lvl FROM Department WHERE Id = 2 UNION all SELECT d.Id,d.Pid,d.DeptName,lvl+1 FROM cte c inner join Department d ON c.Pid = d.Id ) SELECT * FROM cte
SQL递归查询[转载]
原文：http://www.cnblogs.com/pilink/p/6688562.html
