Retorna meses do ano
1 2 3 4 5 |
SELECT 1 AS IdMes, DATENAME(MONTH, 0) AS NomeMes UNION ALL SELECT IdMes + 1, DATENAME(MONTH, DATEADD(MONTH, IdMes, 0)) FROM Meses WHERE IdMes < 12 |
1 2 3 4 5 |
SELECT 1 AS IdMes, DATENAME(MONTH, 0) AS NomeMes UNION ALL SELECT IdMes + 1, DATENAME(MONTH, DATEADD(MONTH, IdMes, 0)) FROM Meses WHERE IdMes < 12 |