|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
September 1st, 2004, 10:33 PM
|
|||
|
|||
|
using identity as a primary key
Hi everybody,
Where I should use identity as a primary key and where shouldn’t? Any examples and suggestions. Thanks in advance rainbow11
|
|
#2
September 7th, 2004, 06:18 PM
|
|||
|
|||
|
My personal rules-of-thumb (and it is decided by the primary key for the table):
1. If the primary key is only one field (or you can't think of which field to use as primary key), create an identity field and use that as the primary key. 2. If the primary key is more than one field, then use those fields as the primary key.
__________________
Up the Irons What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > using identity as a primary key |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
