Get all the date of current year or particular year, below is the scrip to get the record from sql server.
Declare @Year AS INT =DATENAME(YYYY, getdate()) ;
declare @FromDate datetime=DATEADD(yyyy, @Year - 1900, 0),@ToDate datetime=DATEADD(yyyy, @Year - 1900 + 1, -1);
WITH Dates (DateNo) AS (
SELECT DATEADD(DAY, DATEDIFF(DAY, 0, @ToDate) - DATEDIFF(DAY, @FromDate, @ToDate), 0)
UNION ALL SELECT DATEADD(DAY, 1, DateNo)
FROM Dates
WHERE DATEADD(DAY, 1, DateNo) <=@ToDate)
SELECT DateNo as [Date],DATENAME(month, DateNo) as [Month Name],DATENAME(DW, DateNo) as [Day Name]
FROM Dates
option (maxrecursion 365);