SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us


 

Content with tag IDENTITY Rss

Refine your search with one of the following additional tags (with number of items):

T-SQL (4)     Data Types (1)     delete (1)     RESEED (1)    
Truncate (2)     Database Design (1)     Replication (1)     UniqueIdentifier (1)    
CHECKIDENT (1)     DBCC (1)    
   Items 1 to 6 of 6   
 

Identity Crisis

Read more...
By dun 2009/10/29 | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 3,618 reads

TRUNCATE vs DELETE

Read more...
By Noel McKinney 2009/10/09 | Category: IDENTITY
Rating: (not yet rated) |  Discuss |  Briefcase | 4,149 reads

Fastes way to increment an id column

This script shows the fastest way to increment an INT id column.  Read more...
By Florian Reischl 2009/04/02 | Source: SQLServerCentral.com | Category: IDENTITY
Rating: |  Discuss |  Briefcase | 1,250 reads

Replicating Identity Columns

Read more...
By chris.schau 2009/01/19 | Category: Replication
Rating: (not yet rated) |  Discuss |  Briefcase | 3,095 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 | 3,878 reads

RESEED in SQL 2000 and SQL 2005/2008

This article looks at the difference in behavior of RESEED in SQL Server 2000 and SQL Server 2005/2008  Read more...
By Raghuram (AJ) 2008/05/20 | Source: SQLServerCentral.com | Category: RESEED
Rating: |  Discuss |  Briefcase | 3,347 reads
   Items 1 to 6 of 6   
 
 
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use