Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Pros and Cons about automatic increase in MS SQL 2000

Reply
Thread Tools

Pros and Cons about automatic increase in MS SQL 2000

 
 
Benny
Guest
Posts: n/a
 
      03-01-2004
Hello experts,

Currently I am writing a database web application using viusal studio
.net with C#.

Just wondering when come to the database design, what are the pros and
cons about setting the primary key field to automatic increase?

Thanks,

Benny



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Reply With Quote
 
 
 
 
Paul Wistrand
Guest
Posts: n/a
 
      03-01-2004
I'm sure volumes have been written about this but my advice is that its
simple to implement, understand and maintain hence works (for 99.99999% of
web applications anyway). Aside from the whole single key vs composite key
argument the only time I understand that you can run into trouble is when
the uniqueness of the record needs to be maintained across databases. I've
never encountered this requirement personally so maybe someone else who has
could respond but in this case I would try storing a GUID in the record
aside from the primary key.

"Benny" <(E-Mail Removed)> wrote in message
news:O$NP8F0$(E-Mail Removed)...
> Hello experts,
>
> Currently I am writing a database web application using viusal studio
> net with C#.
>
> Just wondering when come to the database design, what are the pros and
> cons about setting the primary key field to automatic increase?
>
> Thanks,
>
> Benny
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP.Net 2.0: Pros and cons of putting connection string in a DLL J.S. ASP .Net 10 05-20-2009 12:51 PM
threading and multicores, pros and cons Maric Michaud Python 24 02-20-2007 07:47 PM
querystring pros and cons, help? =?Utf-8?B?Q2hhcmxlc0E=?= ASP .Net 6 01-12-2006 03:35 PM
Pros and cons for using https on a logon page? Randall Parker ASP .Net 1 12-04-2005 09:14 PM
PSL pros and cons Kumar Vijay Mishra VHDL 2 10-02-2004 12:34 AM



Advertisments