@@DBTS
Returns the value of the current timestamp data type for the current database. This timestamp is guaranteed to be unique in the database.
Syntax
@@DBTS
Return Types
varbinary
Remarks
@@DBTS returns the current database's last-used timestamp value. A new timestamp value is generated when a row with a timestamp column is inserted or updated.
Examples
This example returns the current timestamp from the pubs database.
USE pubs
SELECT @@DBTS