Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag While Loop Rss

   Items 1 to 6 of 6   
 

Instance wide script to add user (the 4th way)

The script can be used to perform any task against all databases hosted on an instance. This is an example script that checks if a user is in a database if it is not then create the user and add it db_datareader role.   Read more...
Rating: |  Discuss |   Briefcase | 534 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 | 37,016 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: cursors
Rating: |  Discuss |   Briefcase | 7,932 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 | 37,016 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 | 959 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 | 624 reads
   Items 1 to 6 of 6   
 
Tags
cursors (3)    
alternative to cursors (1)    
cursor (1)    
data generation (1)    
database size (1)    
dynamic sql (1)    
execute  statement (1)    
fetch (1)    
login (1)    
loop (1)    
master database (1)    
metadata (1)    
performance tuning (1)    
random numbers (1)    
search (1)    
temporary tables (1)    
test data (1)