make a stored procedure

Hi

In my table i have a datetime field
now i want to delete all records there are more than 1 hour old
can someone help me with this

Alvin

Hi,

Here is a possible solution:

delete from tableName
where datettimeField < dateadd(hour, -1, getdate())

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog