Write a SQL Query to find first Week Day of month?
Answers were Sorted based on User's Feedback
Answer / saravakumar
SELECT DATENAME(dw, DATEADD(dd, - DATEPART(dd, GETDATE()) +
1, GETDATE())) AS FirstDay
| Is This Answer Correct ? | 31 Yes | 2 No |
Answer / vijay
SELECT DATENAME(dw, DATEADD(dd, – DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay
| Is This Answer Correct ? | 1 Yes | 1 No |
What is merge?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What is the purpose of the tempdb database?
what is sql server? : Sql server database administration
What is a Stored Procedure?
plz send every query in sql server2000
How to test odbc dsn connection settings?
What is bcp? When does it used?
Can we write a distributed query and get some data which is located on other server and oracle database?
Explain how to integrate the ssrs reports in application?
What is trigger in salesforce?
Explain the storage models of OLAP?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)