You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Returns the value of the current **timestamp** data type for the current database. This timestamp is guaranteed to be unique in the database.
30
+
This function returns the value of the current **timestamp** data type for the current database. The current database will have a guaranteed unique timestamp value.
31
31
32
32
[Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)
33
33
@@ -41,12 +41,12 @@ Returns the value of the current **timestamp** data type for the current databas
41
41
**varbinary**
42
42
43
43
## Remarks
44
-
@@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.
44
+
@@DBTS returns the last-used timestamp value of the current database. An insert or update of a row with a **timestamp** column generates a new timestamp value.
45
45
46
-
The @@DBTS function is not affected by changes in the transaction isolation levels.
46
+
Changes to the transaction isolation levels do not affect the @@DBTS function.
47
47
48
48
## Examples
49
-
The following example returns the current **timestamp** from the [!INCLUDE[ssSampleDBnormal](../../includes/sssampledbnormal-md.md)] database.
49
+
This example returns the current **timestamp** from the [!INCLUDE[ssSampleDBnormal](../../includes/sssampledbnormal-md.md)] database.
0 commit comments