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

Content with tag IDENTITY Rss

   Items 1 to 6 of 6   
 

A Deeply Planted Seed

By Andy Warren 2014/07/01 | Category: identity
Rating: (not yet rated) |  Discuss |   Briefcase | 1,698 reads

Cursor-Killing: Retrieving Recently Modified Data

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? In the next part of an ongoing series, we look at ways to efficiently retrieve recently modified data.  Read more...
By Edward Pollack 2014/06/02 | Source: SQLServerCentral.com | Category: cursor
Rating: |  Discuss |   Briefcase | 6,198 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,168 reads

IDENTITY

By Igor Micev 2014/02/19 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,475 reads

IDENTITY RESEED

By Lokesh Vij 2014/01/24 | Category: identity
Rating: (not yet rated) |  Discuss |   Briefcase | 2,296 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: SQLServerCentral.com | Category: identity
Rating: |  Discuss |   Briefcase | 526 reads
   Items 1 to 6 of 6   
 
Tags
t-sql (3)    
cursor (1)    
deleted (1)    
ident_current (1)    
inserted (1)    
integration services (ssis) (1)    
merge (1)    
performance (1)    
scope_identity (1)    
sequence numbers (1)