This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
If you have an auto incrementing key in the table, you could also do something like:
and store that in a variable in your application. Then, when your timed event kicks off, you have some choices of what to do. You could either run the same query again and then test the returned MAX to what you have locally, or you could run a different query, such as:
You can do a few different things depending on the specific needs of your application.