Get Month Name And Number In SQL SERVER

In this code snippet you will learn how to get monthname and number using SQL SERVER.

SELECT number,
DATENAME(MONTH, CAST(year(getdate()) as varchar(4)) +'-' + CAST(number as varchar(2)) + '-1') monthname
FROM master..spt_values
WHERE Type = 'P' and number between 1 and 12
ORDER BY Number

OUTPUT :

Number   monthname
1              January
2              February
3                   March
4              April
5                   May
6              June
7              July
8              August
9              September
10             October
11                 November
12             December