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 401 20 Dec 2024

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

Revati S Misra

Student

Skilled in SEO, content writing, and digital marketing. Completed several years of working in many organizations including multinational companies. I love to learn new things in life that keep me motivated.

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.

advertising