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 insert and update data into a table with "insert" and "update" statements?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
Explain intellisense for query editing
What the different components of Replication and what is their use?
How does using a separate hard drive for several database objects improves performance right away?
How to remove duplicate rows from table except one?
What are built in functions?
Define inner join? Explain with an example?
What is checkpoint process in the sql server?
How to declare and use cursor variables?
do views contain data ?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What are orphan records?
What is dirty page?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?