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
Explain what is raid and what are different types of raid levels?
Do you think BCNF is better than 2NF & 3NF? Why?
Can we write ddl in trigger?
what is sql server? : Sql server database administration
Do you know what is difference between stored procedure and user defined function?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How to create prepared statements using odbc_prepare()?
What are the types of table?
Can one drop a column from a table?
Can I use sql azure as a backup with log shipping or database mirroring?
What is the difference between system objects and user objects?
Explain the types of indexes.
Can you import Microsoft Excel data to SSRS?
Does sql server 2016 have ssms?
How can you find out which stored procedures are recompiling?