noob06
07-08-2006, 11:46 AM
i have a Class table which has the following fields, className, closingDate, status (open or closed).
How can I have an automatic function in MSSQL which will update the status automatically when the current date is past the closingDate? E.g. if the closing date is 6th June 2006, the status should be updated to Closed when the current date reaches 7th June 2006.
I read through triggers, but they seem to be triggered only when inserting, deleting and updating. pls advise. thanks
How can I have an automatic function in MSSQL which will update the status automatically when the current date is past the closingDate? E.g. if the closing date is 6th June 2006, the status should be updated to Closed when the current date reaches 7th June 2006.
I read through triggers, but they seem to be triggered only when inserting, deleting and updating. pls advise. thanks