On Tue, 2002-05-14 at 20:03, Chris J wrote: > Nope; Sybase (and MS SQL Server which grew from Sybase) have a datatype > called "timestamp". The value in the column bears no relation to the actual > date and time, Hmm, never knew that. Looking at the Syabse FAQ, it's just a counter (@@DBTS). Potentially useful for replication - last replication was max(timestamp)==5; SELECT * from * where timestamp > 5; (pardon the protoSQL ;) Although according to the docs it wraps :) > but is primarilary used where uniqueness is required, How does it generate uniqueness? (Given it wraps, but that's pedantic, I suppose). Key columns are interesting in Sybase - surely everyone who's used it has run into the identity set burn factor :( You shut down Sybase incorrectly, and suddenly wonder why all your ID fields have exploded into massive numbers... Cheers, Alex.
Attachment:
signature.asc
Description: This is a digitally signed message part