Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial

SQL Server Data Types - TIMESTAMP and ROWVERSION

Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5

SQL Server - TIMESTAMP
Syntax TIMESTAMP
Data Binary data that is automatically updated each time the row is modified or inserted
Notes A table can have only one TIMESTAMP column
Storage Size 8 bytes
Standards SQL Server Extension
SQL Server - ROWVERSION
Syntax ROWVERSION
Notes ROWVERSION is a synonym for TIMESTAMP, but Microsoft recommends using ROWVERSION instead of TIMESTAMP
Version Differences ROWVERSION is available since SQL Server 2005

SQL Server TIMESTAMP and ROWVERSION - Equivalents in Other Databases

Database Data Type and Conversion
Sybase ASE TIMESTAMP, automatically generated binary data

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.