jeudi 18 décembre 2014

Microsoft recommends using Rowversion over timestamp , but i can not find "rowversion" data type inside my sql server 2008 R2


MS on this link http://ift.tt/LyDw0e mentioned that we should use rowversion data type over Timestamps. Now inside my sql server 2008 R2 I want to create a column with Rowversion data type, but inside my SQL Server 2008 R2 Management Studio, I cannot find such a data type:


enter image description here


Also when I tried altering existing column named timestamp which is of type timestamp using this statement:



ALTER TABLE [SkillManagement].[dbo].[Customer]
ALTER COLUMN timestamp rowversion


I get this error:



Msg 4927, Level 16, State 1, Line 1
Cannot alter column 'timestamp' to be data type timestamp


Can anyone advise?





Aucun commentaire:

Enregistrer un commentaire