Compares two timestamp values and returns whether they are the same.

Syntax

TSEQUAL ( timestamp1, timestamp2 )

Parameters

Remarks

The TSEQUAL function can only be used in a WHERE clause and is most commonly used as part of an UPDATE statement.

If timestamp1 is equal to timestamp2, a row has changed since it was fetched. If the row changed, its timestamp has been modified and the TSEQUAL function returns FALSE. When the TSEQUAL function returns FALSE, the application determines that no rows were updated and assumes that the row was modified by another user. The updated row is re-fetched.

You can use the TSEQUAL function to determine whether a row has been changed since it was fetched.

See also

• The data type of a timestamp column
• TIMESTAMP special value
• The special Transact-SQL timestamp column and data type

Standards and compatibility

Example

Suppose you create a TIMESTAMP column Products.LastUpdated to store the timestamp for the last time the row was updated. The following UPDATE statement uses the TSEQUAL function to determine whether to update the row. If the value of LastUpdated is '2010/12/25 11:08:34.173226', the row is updated.

UPDATE Products
SET Color = 'Yellow'
WHERE ID = '300'
AND TSEQUAL( LastUpdated, '2010/12/25 11:08:34.173226' );