In my code as of late, I've grown distasteful of Identity fields, doing the best I can
to find a Primary Key by any other means. Identity fields are a last resort. I
remember one time I actually concatenated 7 fields of a 10 field table to do a primary
key. While it seemed weird, it worked
In my code as of late, I've grown distasteful of Identity
fields, doing the best I can to find a Primary Key by any
other means. Identity fields are a last resort.
Distaste for a development practice, by itself, is not an adequate
justification for advocating an alternative development
Distaste for a development practice, by itself, is not an adequate
justification for advocating an alternative development practice. What
caused this distaste?
Gregory Harris
Los Angeles ITA Dept.
[EMAIL PROTECTED]
I think it was the fact that identity fields were not related to PK's and in my
For awhile I tried to avoid using IDENTITY columns in the name of
theoretical "best practices." However, it seemed to cause quite a few
problems in regards to data storage (whatever ended up as the primary key
was invariably larger and more cumbersome than an integer field) and
terribly
To: [EMAIL PROTECTED]
Subject: RE: RE: What are you using instead of IDENTITY?
For awhile I tried to avoid using IDENTITY columns in the name of
theoretical "best practices." However, it seemed to cause quite a few
problems in regards to data storage (whatever ended up as the p
-Original Message-
From: Gary McNeel, Jr. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 11, 2000 3:33 PM
To: [EMAIL PROTECTED]
Subject: RE: RE: What are you using instead of IDENTITY?
Man, am I glad I am not a DBA and let myself get constrained by hypothetical
arguments. We have old
6 matches
Mail list logo