Please visit DEMANDDRAFT.SHOP for quality of products...

Ad

Search This Blog

Monday, April 22, 2013

How to get Month Names by Year in SQL Server

SELECT  DISTINCT CONVERT(VARCHAR(30), WEEKDATE,100) AS MONTH_NAME FROM 
TBL_TEMPDATA WHERE YEAR(WEEKDATE) = 2012

No comments:

Post a Comment