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

Content with tag cursor Rss

   Items 1 to 4 of 4   
 

Check Candidate Columns for NOT NULL Constraints

This script reports table columns that allow NULL values but that currently have no NULL values, making them candidates for adding a NOT NULL constraint.  Read more...
By Charles Jacobus 2013/01/23 | Source: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 543 reads

A simple T-SQL statement to create a list of lookup values

In this article, we provide a simple way to get a comma delimited list from a table of entries without having to use a CURSOR or a WHILE loop to read through the table.  Read more...
By Suresh G. Kumar 2012/09/28 (first published: 2011/03/21) | Source: SQLServerCentral.com | Category: cursor
Rating: |  Discuss |   Briefcase | 32,871 reads

A simple T-SQL statement to create a list of lookup values

In this article, we provide a simple way to get a comma delimited list from a table of entries without having to use a CURSOR or a WHILE loop to read through the table.  Read more...
By Suresh G. Kumar 2012/09/28 (first published: 2011/03/21) | Source: SQLServerCentral.com | Category: cursor
Rating: |  Discuss |   Briefcase | 32,871 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,887 reads
   Items 1 to 4 of 4   
 
Tags
alternative to cursors (1)    
data integrity (1)    
dynamic sql (1)    
maintenance (1)    
system view (1)    
table variables (1)    
t-sql (1)    
while loop (1)