Re: What are cons and pros for using IDENTITY property as PK in SQL SERVER 2000?
This is a discussion on Re: What are cons and pros for using IDENTITY property as PK in SQL SERVER 2000? within the SQL Server forums, part of the Microsoft SQL Server category; --> Consider a user entering categories to allocate stock to. The cotegory description could be a PK (it certainly needs ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 08:02 PM
| ||||
| ||||
 Re: What are cons and pros for using IDENTITY property as PK in SQL SERVER 2000? Consider a user entering categories to allocate stock to. The cotegory description could be a PK (it certainly needs to e unique) except that you want to allow the user to update the value. So although this would logically be a candidate key I wouldn't consider it a good choice for the PK and would add an artificial key to the table. Nigel Rivett www.nigelrivett.net *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!      |
 |
« Access to SQL2000
|
Re: What are cons and pros for using IDENTITY property as PK in SQL SERVER 2000? »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 11:30 PM.
