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 ;
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 ;