Write a SQL Query to find first Week Day of month?
- 2 Answers
- 12266 Views
- I also Faced
- E-Mail Answers
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
Define right outer join in sql server joins?
What are the types of subquery?
Explain hostprotectionattribute in sql server 2005?
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
What is the use of partition by in sql server?
What is the use of keyword with encryption. Create a store procedure with encryption?
Explain indexed views and partitioned view with their syntax.
How to name query output columns in ms sql server?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
How to recompile stored procedure at run time?
What triggers long term care?
What is the difference between getdate and sysdatetime?
Can we do dml on views?
What were the latest updates to SQL Azure service?
Explain what is the difference between union and union all?
