SQLServer 模糊递归查询

代码：

WITH temp ( ParaID, ParaName, ParentID ) AS (
                    SELECT
                        s.ParaID,
                        s.ParaName,
                        s.ParentID
                    FROM
                        SysParameter s
                    WHERE
                        s.isEnable = 1
                        AND s.ParaName LIKE '%模糊查询条件%'

                    UNION ALL

                    SELECT
                        a.ParaID,
                        a.ParaName,
                        a.ParentID
                    FROM
                        SysParameter a
                        INNER JOIN temp ON a.ParaID = temp.ParentID
 ) SELECT *  FROM temp

WITH AS 一般用于递归查询 s.ParaName LIKE '%模糊查询条件%' 进行了模糊查询筛选