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@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--
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.

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 10 2001 - 17:58:39 CST