[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Sheflug] sybase, anyone?



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