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 9 of 9   

Identify Missing Sequence/Identity Numbers

This script is used to identify the missing sequence numbers or identity numbers.  Read more...
By Vignesh Arulmani 2014/11/20 | Source: | Category: missing numbers
Rating: |  Discuss |   Briefcase | 1,036 reads

Using Seqence Container instead of Identity

This script is an example of how to use Sequence, similar to Identity.   Read more...
Rating: |  Discuss |   Briefcase | 1,293 reads

Compare Current IDENTITY Value to DataType's Boundary

This script finds all tables which contain IDENTITY property, and compares the current seed to the maximal boundary of the data type.  Read more...
By Arthur Gimpel 2013/11/18 | Source: | Category: identity property
Rating: |  Discuss |   Briefcase | 558 reads

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: | Category: identity property
Rating: |  Discuss |   Briefcase | 2,957 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: | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 570 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: | Category: primary key (pk)
Rating: (not yet rated) |  Discuss |   Briefcase | 895 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: | Category: identity property
Rating: |  Discuss |   Briefcase | 1,467 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: | Category: identity property
Rating: |  Discuss |   Briefcase | 1,632 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 | 353 reads
   Items 1 to 9 of 9