How do I get the current month and year in SQL?

Try this:

    select 
    case month(getdate())
        when  1 then 'Janeiro'
        when  2 then 'Fevereiro'
        when  3 then 'Março'
        when  4 then 'Abril'
        when  5 then 'Maio'
        when  6 then 'Junho'
        when  7 then 'Julho'
        when  8 then 'Agosto'
        when  9 then 'Setembro'
        when 10 then 'Outubro'
        when 11 then 'Novembro'
        when 12 then 'Dezembro'
    end + ' - ' + cast(year(getdate()) as varchar(4))
 As MesAno

Use DATENAME . See example

SELECT DATENAME(month, GetDate())   + ' de ' +  DATENAME(year, GetDate())

  

Note: DATENAME applies to: SQL Server (SQL Server 2008 up to the current version), Database   Windows Azure SQL data (initial release to current version).   Source: link

Script to return a date in full.

SET LANGUAGE Português

SELECT DATENAME(weekday, GetDate()) + ', '   +
       DATENAME(day, GetDate())     + ' de ' +
       DATENAME(month, GetDate())   + ' de ' +
       DATENAME(year, GetDate())

Remember to use SET LANGUAGE to return the date in the desired language, to check the default language of your session run DBCC UserOptions

To see what names of languages exist in SQL, check the name column of the sysLanguages table.

select * from master.dbo.syslanguages

Note: Avoid using SET LANGUAGE within procedures as this will cause RECOMPILE.