sql 递归查询分类树列表with as

sql 递归查询分类树列表

;WITH cte
AS
(
SELECT
*
FROM t_Base_Menu tbm
WHERE FID=@FCateId
UNION ALL
SELECT
air.*
FROM t_Base_Menu AS air
INNER JOIN cte ON air.FParentID = cte.FID
)
SELECT
FID INTO #temp
FROM cte ;