SQL查询递归

WITHDEPARTMENTAS

(

--定位点成员定义

SELECT*,0ASLEVEL

FROMPE_FC_FileCategoryWHERECategoryID=3--【当前部门ID】

UNIONALL

--递归成员定义

SELECTE.*,Level+1

FROMPE_FC_FileCategoryASE

INNERJOINDEPARTMENTASDONE.ParentID=D.CategoryID

)

SELECT*fromDEPARTMENTOPTION(maxrecursion100)