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:
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