-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of CK
I agree that GUID and auto-increment are the best, however a benefit
of using a GUID is you can predetermine what the value is in your
business layer before you hit the database, and don't have to worry
about retrieving the ID back when running the insert.
-----------------------------------
Exactly. Guid is also able to replicate and not need a column added later
just for replication.
Unfortunately GUID in the index on a table with high velocity inserts sucks
wind.
.........................
Stephen Russell -
Senior Visual Studio Developer, DBA
Memphis, TN
901.246-0159
