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

Define tool Manage Statistics in SQL Server 2000 query ?

0 Answers   NA,

How do you create an execution plan?

0 Answers  

when would you go for denormalization? : Sql server database administration

0 Answers  

Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

Explain about Normalization?

0 Answers   Infosys,




Explain filtered indexes benefits?

0 Answers  

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

Should you normalize audio?

0 Answers  

What are the differences between clustered and non-clustered index?

0 Answers  

What is a transactions?

0 Answers  

What is data source object?

0 Answers  

What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,

For more SQL Server Interview Questions Click Here
Categories