Answer Posted / chris fauvel

--Both use the dateadd function provided by t-sql, I'm sure
oracle and others have similar functions

--this way is a little slower and costlier
select *
FROM sys.tables
where modify_date between dateadd(yy, -5, getdate() ) and
dateadd(yy, -2, getdate() )

--this way is faster and less costly, by not doing the same
--function for every row.
declare @now datetime
, @then datetime
select @now = convert(datetime, convert(varchar, getdate()))
, @then = dateadd(yy, -5, @now)

Select *
from sys.tables
where modify_date between @then and @now

What stored procedure can you use to display the current processes?

894

---

What are sql dirty pages?

1028

---

How to connect php with different port numbers?

1087

---

What is linked report?

131

---

What is difference between clustered and non clustered index?

989

---

What is a transaction and why is it important?

1091

---

In how many ways you can invoke ssrs reports?

139

---

What is sql language?

1146

---

What is optimization and its types?

983

---

Explain the creation and execution of a user-defined function in the sql server?

1051

---

explain the storage models of olap? : Sql server database administration

960

---

What happens when the SQL Azure database reaches Max Size?

111

---

How does recursive cte works in sql server?

1016

---

Is mysql the same as sql server?

989

---

Explain tablesample?

1001

---