Search This Blog

Wednesday, September 29, 2010

SQL Server 2008 Rowversion

The Books Online documentation indicates that timestamp data type syntax is deprecated, and "timestamp is the synonym for the rowversion data type and is subject to the behavior of data type synonyms." However, if we create a table in SQL Server 2008 SP1, using

create table T1
(
id int identity(1,1),
concurrencyID rowversion
)


Then look at the table using:

sp_help T1




This shows the column with a data type of timestamp, not rowversion.
















In fact if we use the Table designer in SSMS, rowversion is not even a choice.








So you cannot choose the rowversion type in the GUI tools in SSMS, but you can in TSQL but SQL server will switch it back to timestamp as demonstrated.

No comments:

Post a Comment