Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-02 : 16:44:34
|
Aecio writes "Hello,
I need to update records in a table based on the date. The table is of news articles and two of the fields are Date Published and a boolean field Publish. I need to check at least once a day if the current date is equal to the datPublished and if so, change the value of the bolPublished field to 1.
At the moment I do this manually, running an ASP page daily that in turn runs an UPDATE tblArticles SET bolPublished=1 WHERE datPublished = (ASP inserts the current date here in SQL prefered format).
I am sure there is a way to do this automatically with MSSQL Server 7. Could you shed some light as to how to do this?
Thank you very much.
Aecio" |
|
|
|
|
|
Date triggered table update query