unique and can always be used as the key.
Check the US gov sites for the list...
_____
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]
