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