How will you collect the date from current date to last
older 6 days date in sql server 2005
Answer Posted / jitendra sharma
SELECT DATEADD(DD,-6,GETDATE()) this is right...........
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to test values returned by a subquery with the in operator?
What is a document index?
What happens if the update subquery returns no rows in ms sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
How many partitions a clustered index has by default in sql server 2012?
Define synonym?
How to change server name in sql server?
Explain intellisense for query editing
How can you append an identity column to a temporary table?
how would you improve etl (extract, transform, load) throughput?
what is an index? : Sql server database administration
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
How many types of the database links?
What are statistics?
What is the difference between stored procedure and functions?