Dear SQL gurus,
I have some questions on database design and hope all experts out there
can give me some ideas/advice.
Please advise/comment on the followings:-
1. Should one use the identity field as primary key in designing a
database?
If yes, isn't it has a limitation when the number reaches its
limits?
2. What would happens to the database when the identity field's value
reaches its limits?
3. Any advice on selecting a primary key for a table where none of the
columns has unique value?
Thanks in advance.
Kind regards,
CTLoo
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
