SELECT DATENAME(dw, DATEADD(dd, – DATEPART(dd, GETDATE()) + 1, GETDAT

Write a SQL Query to find first Week Day of month?

Question Posted / vijay

Answer Posted / vijay

SELECT DATENAME(dw, DATEADD(dd, – DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is nonclustered index with included columns ?

962

Explain datetimeoffset data type in sal server 2008?

902

what is raid and what are different types of raid configurations? : Sql server database administration

1032

What is a document index?

1022

How do I start and stop sql server?

1016

What is a covered index?

932

What do you mean by authentication modes in sql server?

1081

What are policy management terms?

981

What is a performance monitor?

972

What is the difference between a local and a global temporary table?

1107

What is the maximum size of sql server database?

999

Define clusters?

1058

Tell me what is de-normalization and what are some of the examples of it?

1023

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1032

What is resource db in sql server?

1014