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

Content with tag While Loop Rss

   Items 1 to 5 of 5   
 

Cursors Be Gone!

A short tutorial on converting cursors to more conventional loops.  Read more...
By Gaby Abed 2010/06/18 (first published: 2008/12/24) | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 36,903 reads

4 Ways to Increase Your Salary (Using UPDATE)

This article depicts how to approach row by row updates needed in a salary table. It might not directly let you increase your salary, but it could help you at review time.  Read more...
By Arup Chakraborty 2009/11/26 | Source: SQLServerCentral.com | Category: cursor
Rating: |  Discuss |   Briefcase | 7,916 reads

Cursors Be Gone!

A short tutorial on converting cursors to more conventional loops.  Read more...
By Gaby Abed 2010/06/18 (first published: 2008/12/24) | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 36,903 reads

search every database on server from a single sp

i have recently had the need to search the every database on the server for a particular string. i came up with this... it has lots of room for improvement but it works  Read more...
By Chris Morton 2008/12/19 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 950 reads

Create Sample Data Script

in this scripts there are two methods of creating sample data for a gambling application. i have used both cursors and loops.  Read more...
By Chris Morton 2008/10/10 | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 578 reads
   Items 1 to 5 of 5   
 
Tags
cursors (2)    
alternative to cursors (1)    
cursor (1)    
data generation (1)    
dynamic sql (1)    
execute  statement (1)    
fetch (1)    
loop (1)    
master database (1)    
metadata (1)    
performance tuning (1)    
random numbers (1)    
search (1)    
temporary tables (1)    
test data (1)