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