• SELECT DATENAME(month, @MonthNumber)

    Example: SELECT DATENAME(month,1)

    Result: January