Sql updating a row

Rated 4.56/5 based on 685 customer reviews

(For example, if a column value is 5, and an update statement sets the value to 5, this action is considered an update even though there is no change, and the rowversion is incremented.) timestamp is the synonym for the rowversion data type and is subject to the behavior of data type synonyms.In DDL statements, use rowversion instead of timestamp wherever possible.

So while updating the TARGET table, TERADATA won’t be able to understand from which row it should update the TARGET row i.e.You can use the rowversion column of a row to easily determine whether the row has had an update statement ran against it since the last time it was read.If an update statement is ran against the row, the rowversion value is updated.This value must be replaced by the actual rowversion value.An example of the actual rowversion value is 0x00000000000007D3.

Leave a Reply