Write a SQL Query to find first Week Day of month?
Answer Posted / vijay
SELECT DATENAME(dw, DATEADD(dd, – DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is function of master database?
Write a query for primary key constraint with identity key word?
What is GUID in sql server?
When to use null data driven subscription?
Why are you getting errors when creating a new odbc dsn?
Explain the truncate command? : SQL Server Architecture
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
how you can configure a running aggregate in SSRS?
Does server sql treat char as a variable-length or fixed-length column?
Can we insert data into view sql server?
Explain the advantages of merge replication?
What happens if the update subquery returns multiple rows in ms sql server?
What is the maximum size of column in sql server?
How to check table values in sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration