Share via

@@DBTS (SQL Server Compact)

  • Article

@@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.

Important

Any INSERT, UPDATE and CREATE queries will internally increment the rowversion values.

Syntax

@@DBTS

Example

Select @@DBTS

Remarks

@@DBTS value is not rolled back when a transaction rolls back or when an INSERT or UPDATE query causes an error.