When creating a new table for browsing, include a column named timestamp in the table definition. This column is automatically assigned the timestamp datatype; you do not have to specify its datatype. For example:
create table newtable(col1 int, timestamp, col3 char(7))
Whenever you insert or update a row, Adaptive Server timestamps it by automatically assigning a unique varbinary value to the timestamp column.
Copyright © 2005. Sybase Inc. All rights reserved. |