1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / saravakumar

Answers were Sorted based on User's Feedback



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

Answer / saravakumar

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

Is This Answer Correct ?    31 Yes 2 No

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

Answer / vijay

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

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How to rename databases in ms sql server?

0 Answers  

What is ddl and dml commands?

0 Answers  

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

What are distributed partitioned views?

0 Answers  

What are cursors?

8 Answers  




How to find table changes in sql server?

0 Answers  

CTE(common table expression)

1 Answers   Thomson Reuters,

what is an extended stored procedure? : Sql server database administration

0 Answers  

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

What is wrong with sql server client libarary dll, ntwdblib.dll?

0 Answers  

How do triggers work?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories