Answers for "sql server day of week name"

sql server week number

datepart(wk, DateToParse)

sql server get week dates from week number

SELECT  
	DATEADD(DAY, 2 - DATEPART(WEEKDAY, GETDATE()), CAST(GETDATE() AS DATE)) [Week_Start_Date],  
	DATEADD(DAY, 8 - DATEPART(WEEKDAY, GETDATE()), CAST(GETDATE() AS DATE)) [Week_End_Date]

get week day name sql server

select datename(dw,getdate()) --Thursday
select datepart(dw,getdate()) --2