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 reference section?

1002

How do you set a trace flag in sql server?

1036

What is instead of dml trigger?

1004

How to link tables in sql server?

935

Mention the 3 ways to get a count of the number of records in a table.

978

Can you move the resources after pausing the node? : sql server database administration

1103

What are trace flags?

1032

What are the types of database recovery models?

1125

Explain about unique identifier data type in sql server?

918

How do I completely remove sql server instance?

1102

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1942

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

909

What is the meaning of resultset type_scroll_insensitive?

956

what's the difference between delete table and truncate table commands? : Sql server database administration

982

How can you know if the row fetched from cursor is still valid in underlying table?

998