Hi All.
I need to create a trigger in my image table. I want images older than 5 days to be automatically deleted from the table.
example:
create trigger Delete_old_Images
as delete from Image_Table
where ImageID = 5 days old
I do not know how to accomplish this. Can somebody help me.
Thanks in advance