Recursive CTE to Generate Sequnce Numbers upto any limit

WITH CTE (num) AS (

SELECT 1

UNION ALL

SELECT num+1

FROM CTE

WHERE num<90000

)

SELECT DISTINCT num FROM CTE c1

OPTION (MAXRECURSION 0)