sqlserver递归查询

with tmp   as( 
SELECT * FROM  TBasDepartment WHERE DepartmentID=511
union   all 
SELECT a.* FROM  TBasDepartment a,tmp b WHERE a.PDepartmentID   =   b.DepartmentID
) 


SELECT * FROM tmp