All geek questions in one place

Is rowversion an invalid data type in SQL Server 2008 R2?

Is rowversion invalid data type in Microsoft SQL Server 2008 R2?

Bonus Chat

I am trying to add a rowversion column to a table:

enter image description here

But when I try to leave the Data Type column, SQL Server Management Studio complains

Invalid data type.

enter image description here

and insists that I choose a different data type:

enter image description here

How to make a rowversion column when rowversion not a valid data type?

View Bonus

enter image description here

Reading bonuses

rowversion (Transact-SQL)

timestamp is a synonym for rowversion data type and depends on the behavior of data type synonyms. For DDL operations, use rowversion instead of timestamp where possible. For more information, see Data Type Synonyms (Transact-SQL) .

The timestamp syntax is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new developments and plan to change applications that currently use this feature.

Extra bonus chat

+6
source share
3 answers

SQL Server 2008 R2 accepts ROWVERSION as the data type for columns in CREATE TABLE statements, but SSMS seems to be lagging, and the designer refuses to accept the input.

+4
source

If any help, the Visual Studio 2012 SQL Server Explorer Explorer designer has a rowversion parameter (even though the Windows Server Server Explorer connection designer does not support it).

enter image description here

+4
source

"The timestamp syntax is deprecated. This feature will be removed in a future version of Microsoft SQL Server." so I think timestamp = rowversion.so you don't need the rowversion version.

0
source

Source: https://habr.com/ru/post/906700/

More articles:


All Articles