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

How do I setup a sql server database?

996

---

What is command parameter in ssrs?

153

---

What are different types of roles provided by ssrs?

144

---

What is the main difference between ‘between’ and ‘in’ condition operators?

1102

---

Explain datetimeoffset data type in sal server 2008?

847

---

What are null values in ms sql server?

1018

---

What is Command line parameters in PLSQL.?

1057

---

What is stored in the mssqlsystemresource database? : sql server database administration

986

---

What are the differences between sql server and mysql.

1019

---

What structure can you implement for the database to speed up table reads?

1154

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1801

---

What is the difference between a check constraint and a rule?

1129

---

List the different index configurations possible for a table?

881

---

What is clustered vs nonclustered index?

881

---

What are the different acid properties?

1011

---