I use Miscrosoft SQL Server 2012 and because this article says:
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.
I decided to use the "rowversion" column instead of the "timestamp" column. So, I created the following table:
CREATE TABLE [dbo].[TestTable]
(
[Col001] [INT] NOT NULL
,[Col002] [CHAR](2) NOT NULL
...
,[Col00N] [DATETIME2] NOT NULL
,[RowVersionID] [ROWVERSION] NOT NULL
,CONSTRAINT [PK_ProtoSurveyGlobalizationChanges_RowVersionID] PRIMARY KEY CLUSTERED
(
[RowVersionID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
And everything was fine until I pressed the ALT + F1 combination, which gives me information about my table (for example, the details of the columns), and I saw that the column "RowVersionID" has a label with the type "timestamp".
, , , " " SQL Server Management Studio 2012, " SQL" :
[RowVersionID] [timestamp] NOT NULL
, , "timestamp" , - ?