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

Content with tags T-SQL, IDENTITY Rss

   Items 1 to 3 of 3   
 

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

IDENTITY

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

IDENTITY RESEED

By Lokesh Vij 2014/01/24 | Category: identity
Rating: (not yet rated) |  Discuss |   Briefcase | 2,296 reads
   Items 1 to 3 of 3   
 
Tags
cursor (1)    
deleted (1)    
inserted (1)    
merge (1)    
performance (1)    
scope_identity (1)