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
- 4 Answers
- 6045 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 the difference between cube operator and rollup operator? : SQL Server Architecture
Differentiate between truncate vs delete in mssql?
How to download microsoft sql server 2005 express edition?
How many types of built in functions are there in sql server 2012?
What is difference between equi join and inner join?
How to rename an existing column with sql server management studio?
What are the differences between triggers and stored procedures?
What are scheduled tasks in sql server?
What is rank function?
If user is owning any SQL Objects, can we drop that user
How to get the definition of a trigger back?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Describe in brief authentication modes in sql server.
What does null mean?
