Returns the value of the current timestamp data type for the current database. This timestamp is guaranteed to be unique in the database.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
@@DBTS returns the last-used timestamp value of the current database. A new timestamp value is generated when a row with a timestamp column is inserted or updated.
The @@DBTS function is not affected by changes in the transaction isolation levels.
The following example returns the current timestamp from the AdventureWorks2012 database.
USE AdventureWorks2012; GO SELECT @@DBTS;