:::: MENU ::::

Cannot update a timestamp column

  • Jun 17 / 2009
  • 0
Data Types, dbDigger, T-SQL Interview Questions

Cannot update a timestamp column

The error message

Msg 272, Level 16, State 1, Line 4
Cannot update a timestamp column.

is a run time error message and appears when you try to update a table column of type TIMESTAMP. Values in a column of type TIMESTAMP can not be modified with an UPDATE statement. These values are generated and modified by SQL Server. This error can occur on all versions of SQL Server.
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.

Consult us to explore the Databases. Contact us