Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » SQL dialects and compatibility » Configuring databases for Transact-SQL compatibility


The special Transact-SQL timestamp column and data type

SQL Anywhere supports the Transact-SQL special timestamp column. The timestamp column, together with the TSEQUAL system function, checks whether a row has been updated.

Two meanings of timestamp

SQL Anywhere has a TIMESTAMP data type, which holds accurate date and time information. It is distinct from the special Transact-SQL TIMESTAMP column and data type.

 Creating a Transact-SQL timestamp column in SQL Anywhere
 The data type of a timestamp column
 Using TSEQUAL for updates