Get Name of the month from the sql server from month

///////For the full name

select DateName(MM,DATEADD(MM,Month(getdate())-1,0))


///////For the full name

select left(DateName(MM,DATEADD(MM,Month(getdate())-1,0)),3)

//////////// Result

1. August

2. Aug