sql递归查询部门数据

 with cte as 
 ( 
 select a.DepartCode,a.DepartName,a.ParentDepartCode from tbDeparts a where ParentDepartCode='2' 
 union all  
 select k.DepartCode,k.DepartName,k.ParentDepartCode  from tbDeparts k inner join cte c 
 on c.DepartCode = k.ParentDepartCode 
 )
 select * from cte