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 the correct order of the logical query processing phases?
When you should use a low fill factor?
How to create new tables with "create table" statements in ms sql server?
Explain the types of indexes.
Will sql server 2005 allow you to reduce the size of a column?
What are the types of database recovery models?
i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?
What is the main difference between ‘between’ and ‘in’ condition operators?
When columns are added to existing tables, what do they initially contain?
Define inner join in sql server joins?
What the different topologies in which replication can be configured?
What are the different types of replication? How are they used?
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)