Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How to insert and update data into a table with "insert" and "update" statements?

1042


How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

176


Explain intellisense for query editing

1074


What the different components of Replication and what is their use?

1125


How does using a separate hard drive for several database objects improves performance right away?

988


How to remove duplicate rows from table except one?

1062


What are built in functions?

1067


Define inner join? Explain with an example?

1046


What is checkpoint process in the sql server?

1074


How to declare and use cursor variables?

1252


do views contain data ?

1020


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

1157


What are orphan records?

986


What is dirty page?

1035


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1166