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
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is the difference between dropping a database and taking a database offline?
What do you mean by a Composite primary key?
What is temporary table in sql server? Why we use temp table?
Explain user defined views?
How to use values from other tables in update statements in ms sql server?
How to download microsoft sql server 2005 express edition?
What are the advantages of having an index on the sql server?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What is an example of a primary key?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What are drillthrough reports?
How do I manually uninstall an instance of sql server 2016?
Explain system functions or built-in functions? What are different types of system functions?