RSS Forums RSS
Please support our MS SQL advertiser: Programming Forums

Autonumber in a SQL Server table

Join Date: Jun 2005
Posts: 12
Reputation: relawson is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
relawson relawson is offline Offline
Newbie Poster

Re: Autonumber in a SQL Server table

  #9  
Jun 12th, 2005
I believe that would be superior DB design because not only do you have a unique PK for each identifying row, it is unique across the DB. Maybe that is 4 or 5 NF...I never read much past 3 :-) I only wish identifying columns would autoincrement the "master counter" so it was automated like MS SQL. A combination of the two if you will. That may present a locking issue...but I am sure they thought of that.

Thanks for the great response.
Reply With Quote  
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 11:20 am.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC