Question
March 14, 2008 at 04:39 AM
priscilla_geetha2k

MS SQL SERVER query to return month names for a year

by priscilla_geetha2k . Updated 18 years, 5 months ago

Hi ,
I want to load a combo box with the names of all months in a year. I want to do it using MS SQL Server query. I used
SELECT DATENAME(month, getdate() AS ‘Month Name’
this only returns the current month’s name. I want the names of all months in a year. pls help
thanks in advance

This discussion is locked

All Comments