SQL Server database (timestamp timestamp) type

1. Exposes the data type of a unique binary number that is automatically generated in the database.

2.timestamp is typically used as a mechanism for adding a version stamp to a table row.

3. The storage size is 8 bytes. A non-nullable timestamp column is semantically equivalent to a binary (8) column. The nullable timestamp column is semantically equivalent to the varbinary (8) column. This will cause the timestamp type obtained in the C # program to become the byte[] type. So if we need to get and use this timestamp from the database, we have to go through the conversion.

The 4.timestamp data type is just an incremented number and does not hold the date or time. To record a date or time, use the datetime data type.

5. A table can have only one timestamp column. The values in the timestamp column are updated each time the row that contains the timestamp column is inserted or updated. Any updates to the row will change the timestamp value.

6. The use of cached data, timestamp records the time of the data change, the next time the value is larger than the last time, in the program read more than the last Max (timestamp) data, is the latest changed data

. Summary: The SQL Server timestamp data type is independent of time and date. SQL Server Timestamp is a binary number that indicates the relative order in which data modifications occur in the database. The implementation of the timestamp data type was originally intended to support the SQL Server recovery algorithm. Each time the page is modified, it is marked with the current @ @DBTS value and then @ @DBTS plus 1. This is sufficient to help the recovery process determine the relative order of page modifications, but the timestamp value has no relation to time. @ @DBTS Returns the last timestamp value used in the current database. When you insert or update a row that contains a timestamp column, a new timestamp value is generated.

SQL Server database (timestamp timestamp) type