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,761 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: | Category: cursor
Rating: |  Discuss |   Briefcase | 6,264 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,195 reads


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


By Lokesh Vij 2014/01/24 | Category: identity
Rating: (not yet rated) |  Discuss |   Briefcase | 2,318 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
Rating: |  Discuss |   Briefcase | 529 reads
   Items 1 to 6 of 6   
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)