Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

SQL Query to print all the month name.

Revati S Misra 513 20 Dec 2024

Write an SQL Query to print all the month names of a year.

1 Answers

Ashutosh Patel 20 Dec 2024

You can print all the names of the months in the SQL server by using SQL Recursive CTE.

Here is the simple SQL Query,

USE your_database
GO
WITH CTE_MonthName(Number, MonthName ) AS
(
SELECT 0, DATENAME(MONTH, DATEADD(MONTH, 0, DATEFROMPARTS(YEAR(GETDATE()), 1, 1)))
UNION ALL
SELECT Number+1, DATENAME(MONTH, DATEADD(MONTH, Number+1, DATEFROMPARTS(YEAR(GETDATE()), 1, 1))) FROM CTE_MonthName WHERE Number < 11
)
SELECT MonthName FROM CTE_MonthName

Output:

Also, Read: SQL Query to print Week days.

MindStick Training

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.