Transaction start-ID

The transaction start-ID column captures the time of the first data change operation in the transaction.

If multiple rows are inserted or updated within a single SQL transaction, then the values for the transaction start-ID column are the same for all the rows and are unique from the values generated for this column by other transactions. When the transaction start-ID column is not null, you can use it to identify all the rows in the tables that were written by the same transaction. If the transaction start-ID is defined to allow the NULL value, it is set to a value only when the transaction start-ID does not match the row-begin column's value. The difference between the transaction start-ID and the row-begin column are explained further in the System-period temporal table timestamp value conflicts topic.