Re: SQL to determine when a row was inserted/updated

This is a situation that we had to solve for our systems. All tables are created with two extra fields, one captures the datetime when the row is updated/inserted and the other captures the name of the user who last updated the row. Then triggers are applied to the table to automatically set this information on insert or update. On some tables we have added a third column, a version number. This gets set to 1 during an insert and incremented during an update. Daniel Williams <danny@uk.ibm.com> wrote in article <33B8FBAD.2781@uk.ibm.com>... > Hi there! > > Is there some SQL that can be run to get a list of when rows were > inserted into a table and also when they were updated? > > Dan >