Find Month Name to Month number in SQL Server

//Current Month Name and Month number Find in SQL Server

SELECT MONTH(LEFT(DATENAME(MONTH,Getdate()),15) + ' 1 2016') Number ,(DATENAME(MONTH,Getdate())) MonthName

OutPut :-