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

Explain some stored procedure creating best practices or guidelines?

0 Answers  

Explain trigger and trigger types?

0 Answers  

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

0 Answers  

What are the difference between data length and length in SQL Server-2008?

3 Answers   Scio Healthcare,

Are null values the same as that of zero or a blank space?

0 Answers  




When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

Explain DBCC?

0 Answers   QuestPond,

CREATE a table from another table

2 Answers  

Creating Tables Using SELECT

1 Answers  

How to convert binary strings into integers in ms sql server?

0 Answers  

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

For more SQL Server Interview Questions Click Here
Categories