Re: Identity key?
From: Joe Celko <71062.1056_at_compuserve.com>
Date: Wed, 10 Jan 2001 23:58:39 GMT
Message-ID: <93isvb$q3r$1_at_nnrp1.deja.com>
Date: Wed, 10 Jan 2001 23:58:39 GMT
Message-ID: <93isvb$q3r$1_at_nnrp1.deja.com>
>> PS: Sometime the natural key might not be in your best interest: I
remember two guys who put a time stamp as primary key and started
inserting data using the server clock as key generator. They were
baffeled by the server who complained that some data integrity
violation occured. But they were brave and solved the problem: they put
wait(100ms) in the code. <<
My first guess was that they set their clock to Daylight Saving Time and shot themselves in the foot...
--CELKO--
Sent via Deja.com
Joe Celko, SQL Guru & DBA at Trilogy
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc)
which can be cut and pasted into Query Analyzer is appreciated.
http://www.deja.com/