2
Answers

How to get month list in SQL Server?

Deepak M

Deepak M

5y
532
1
Hello to all,
 
 
How to get all month list of a year by a given year with out using loop like below stracture.
MID   MNAME
1         Jan-20
2         Feb-20
3         Mar-20
4         Apr-20
5         May-20
6         Jun-20
7         Jul-20
8         Aug-20
9         Sep-20
10       Oct-20
11       Nov-20
12       Dec-20
Answers (2)