TranID Column

The _tranid special column contains a unique 64‑bit transaction identifier. You can specify the _tranid special column as an additional primary key in historical tables.