Apr 11, 2010 10:12 AM|TajKhan|LINK
In my application i want add record in database with the date. My need is that particular record should be deleted on a given date.
Example: i have added one record on 1 Apr 2010 and it will be deleted on 25 Apr 2010.
Any idea how to achieve this? I need a logic to delete that particular record automatically from the database on a given date. I am using MS SQL 2005.