I have SQL SERVER 2005 and I have a table with a Cloumn DATETIME data Type,
I want to ceate a trigger that checks the table rows and delete the record (s) when it has (DATETIME colume value - today date()) >20 days.
Is it possible to write a trigger for that?
I am new to SQL Server and trigger.
View Complete Post