TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Paresh Zanzarukiya
NA
2
3.1k
Trigger that removes data older than one week
Apr 3 2013 3:27 PM
Hi,
I want to create trigger in SQL server that removes record which are older than one week.
I have date field in table, after inserting record in this table, it should automatically removed from table after one week. I want trigger to create trigger for that.
So help me how to create such trigger that fires after some time interval.
Thanks.
Reply
Answers (
2
)
Legacy Database System
Alternative for SQL Cursor or While loop ?