sql column with month name code example

Example: monthname sql

SELECT DATENAME(mm,GETDATE())[Month Name]