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

Related posts about sql

Related posts about sql-server