@@DBTS returns the value of the current rowversion (timestamp) data type for the database. The rowversion is guaranteed to be unique in the database. @@DBTS returns a varbinary which is the last-used rowversion value of the current database. A new rowversion value is generated when a row with a rowversion column is inserted or updated.
.gif) Important |
|---|
Any INSERT, UPDATE and CREATE queries will internally increment the rowversion values. |
Syntax
Example
Remarks
@@DBTS value is not rolled back when a transaction rolls back or when an INSERT or UPDATE query causes an error.