primary key datatype in sql server database
Posted
by ooo
on Stack Overflow
See other posts from Stack Overflow
or by ooo
Published on 2010-05-22T19:19:08Z
Indexed on
2010/05/22
19:30 UTC
Read the original article
Hit count: 200
i see after installing the asp.net membership tables, they use the data type "uniqueidentifier" for all of the primary key fields.
I have been using "int" data type and doing increment by one on inserts.
Is there any particular benefits to using the uniqueIdentifier data type compared to my current model of using int and auto increments on new inserts ?
© Stack Overflow or respective owner