Cannot update a timestamp column
Msg 272, Level 16, State 1, Line 4
Cannot update a timestamp column.
This error message appears when you try to update a table column of type TIMESTAMP.
The T-SQL statement can be parsed, but causes the error at runtime.
Error of the Severity Level 16 are generated by the user and can be fixed by the SQL Server user. You cannot modify values in a column of type TIMESTAMP with an UPDATE statement. These values are generated and modified by SQL Server.
All versions of SQL Server
CREATE TABLE #t
INSERT INTO #t DEFAULT VALUES
SET TIMESTAMP = TIMESTAMP + CAST(1 AS BINARY(8))
DROP TABLE #t
The data type TIMESTAMP has nothing to do with DATE, TIME, or a combination of both values. Values of type TIMESTAMP are binary numbers. The synonym ROWVERSION is a much clearer description for this data type.