Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My question is basically this on the title of the topic.
I have a table that can be updated, but on its own doesn't have a modification time field.
What do i do ?
If you are using SQL Server, you can add a type rowversion column to the table. That will allow you to easily detect new or changed rows. Other database platforms may have a similar option.
If that is not a solution, could you describe your data a bit more? Is is only new rows you need or changed rows as well? Is there some sort of incrementing record identifier?
-Rob