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 are Spatial data types in SQL Server 2008

1067

What options are available to audit login activity? : sql server security

1195

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

1036

What are the tools available in market as an alternative to sql server reporting services?

138

how you can move data or databases between servers and databases in sql server? : Sql server administration

1026

What is standby servers? Explain types of standby servers.

1050

What is difference between views and stored procedures?

1027

Explain about Views?

1120

What are magic tables in sql server?

1197

Is sql different from sql server?

1158

What is difference between rownum and rowid?

954

Is natural join and equi join same?

1027

Using the customer, and order table in northwind database, please write a query to produce xml?

1113

Is foreign key a primary key?

1171

What are triggers in ms sql server?

1224