tony
-----Original Message-----
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 10:43 PM
To: CF-Talk
Subject: Re: Primary key preference quick poll
No two country codes are the same - makes a good natural primary key.
There is no need to create synthetic key in this situation (and
additional index on the country code column). However, for most cases I
use synthetic key - just to make sure I don't run into a wall one day.
TK
----- Original Message -----
From: Tony Weeg
To: CF-Talk
Sent: Monday, November 10, 2003 10:29 PM
Subject: RE: Primary key preference quick poll
even then, no matter what, you can always find a way to use an int.
why with country codes?
tony
-----Original Message-----
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 10:24 PM
To: CF-Talk
Subject: Re: Primary key preference quick poll
Almost always int, rarely a char (like country codes etc).
TK
----- Original Message -----
From: Sutton Yamanashi
To: CF-Talk
Sent: Monday, November 10, 2003 9:09 PM
Subject: Primary key preference quick poll
Why do you prefer
1. int (Identity / auto_increment)
2. char maybe with CreateUUID()
3. varchar
other?
Thanks!
-sutton
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
