Delete items older than a day - SQL Server

Viewed 60870

In a table in my datatase I have a datatime column which stores the time at which the record is added. How can I delete all records which are older than a day when I run a stored procedure (considering the current time) ?

7 Answers
Related