How will you collect the date from current date to last
older 6 days date in sql server 2005
- 4 Answers
- 5504 Views
- I also Faced
- E-Mail Answers
Answer Posted / gopi muluka
Using DATEADD Function compare get the requited values
SELECT DATEADD(DD,-6,GETDATE())
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is spid in sql server profiler?
Explain what is row_number function?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
How to link tables in sql server?
Can we insert data into view sql server?
What is change data capture (cdc) feature?
Explain go command in sql server?
What is normalization? Explain its different types?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
If a stored procedure is taking a table data type, how it looks?
what are candidate key, alternate key and composite key? : Sql server database administration
What is statement level trigger?
When you use @@error and try-catch?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Which table keeps information about stored procedures?
