For ones that need to be a little more secure than others, I use
uniqueidentifier with the default set to NewID().
Most anything else, I will agree with Tony.
Ricky
_____
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 8:16 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll
id int auto increment
tony
-----Original Message-----
From: Jeff Garza [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 9:13 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll
I prefer Identitity myself... we don't do any cross server replication,
so
we don't need UUIDs.
Cheers,
Jeff
_____
From: Sutton Yamanashi [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 7:09 PM
To: CF-Talk
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]
