Answer Posted / tp
select * from table1 where date between dateadd(yy,-
5,getdate()) and getdate()
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is database replicaion? : Sql server database administration
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Disadvantages of the indexes?
How can you tell if a database object is invalid?
What to check if a User database is locked?
How adventureworkslt tables are related?
How you can move data or databases between servers and databases in sql server?
What the different components in replication and what is their use?
What are 3 ways to get a count of the number of records in a table?
What are various ways to enhance the ssrs report?
What is the difference between char and varchar2 datatype in sql?
How to create a view using data from another view?
How do I install sql server?
Explain about service Broker functions?
Mention what are the different types of ssrs reports?