Auto Delete after time period from table

Jun 11 2015 6:07 AM

Hi friends,

I have a table in which a customer adds his product details.

what i have to do is, need to delete the product after 30 days and show message before 5 days of expiry.

If possible then a email message is send at the time of deletion.

need help in SQL tables, procedure and c# .

plz help....

Answers (3)