Get month list at runtime in SQL Server

WITH CTE
AS 
( SELECT 1 AS MonthNumber
UNION ALL
SELECT  MonthNumber + 1 -- add month number to 1 recursively
FROM CTE
WHERE  MonthNumber < 12 -- just to restrict the month number upto 12
)
SELECT
MonthNumber,
DATENAME(MONTH,DATEADD(MONTH, MonthNumber ,0)- 1)[MonthName]                                                                                                        -- function to list the monthname.
FROM CTE