664
技術社區[雲棲]
SQL查詢遞歸
WITH
DEPARTMENT
AS
(
--定位點成員定義
SELECT
*,0
AS
LEVEL
FROM
PE_FC_FileCategory
WHERE
CategoryID=3
--【當前部門ID】
UNION
ALL
--遞歸成員定義
SELECT
E.*,Level+1
FROM
PE_FC_FileCategory
AS
E
INNER
JOIN
DEPARTMENT
AS
D
ON
E.ParentID=D.CategoryID
)
SELECT
*
from
DEPARTMENT
OPTION(maxrecursion
100)
最後更新：2017-04-02 22:16:33