Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag IDENTITY Property Rss

Search for any content tagged identity property

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 6 of 6   
 

Generate insert statements with column names for any or all tables

Generate a script of insert statements with column names for any table including those with identity columns.  Read more...
By Darren Gordon 2012/06/15 | Source: SQLServerCentral.com | Category: identity property
Rating: |  Discuss |   Briefcase | 2,875 reads

Expanding identity to negative values

Identity integer can be max 2mld, if the table has many rows I can expand the identity.  Read more...
By Federico Iori 2012/02/10 | Source: SQLServerCentral.com | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 564 reads

proc to change PK

This script was created for a client who had uniqueidentifier PKs, but wanted to switch to BIGINT IDENTITY PK for better db performance.  Read more...
By colin_sloss 2011/03/24 | Source: SQLServerCentral.com | Category: primary key (pk)
Rating: (not yet rated) |  Discuss |   Briefcase | 891 reads

Script to check current identity of Tables

Used to check all current identities on all user tables  Read more...
By Sean Kotze 2010/03/17 | Source: SQLServerCentral.com | Category: identity property
Rating: |  Discuss |   Briefcase | 1,445 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 property
Rating: |  Discuss |   Briefcase | 1,623 reads

Reset Identity Seeds

Resets the identity seeds for all user tables to one plus the current maximum value of the identity field. Revised 24 August 2010.  Read more...
By Jeff Roughgarden 2006/08/14 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 335 reads
   Items 1 to 6 of 6