SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Database Design, IDENTITY Property Rss

   Items 1 to 2 of 2   

Using IDENTITY as a key column

By Hugo Kornelis 2010/04/20 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 4,586 reads

Auto generated SQL Server keys - uniqueidentifier or IDENTITY

I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?  Read more...
By Additional Articles 2008/10/23 | Source: MSSQLTips.com | Category: t-sql
Rating:  Rate this |   Briefcase | 5,744 reads
   Items 1 to 2 of 2   
datatypes (1)    
t-sql (1)    
uniqueidentifier (1)