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 6 of 6   
 

Right or Wrong, Dynamic SQL AND a Cursor

I'm no big fan of dynamic SQL or cursors, however there are times where they do the job.   Read more...
By Kurt Zimmerman 2013/11/08 | Category: transaction logs
Rating: |  Discuss |   Briefcase | 1,610 reads

Virtual tally table function

An inline table-valued function (iTVF) that will produce a virtual tally table on-the-fly. The function creates a tally table of any size with user-defined lower and upper bounds.  Read more...
By Steven Willis 2013/07/23 | Source: SQLServerCentral.com | Category: tally
Rating: |  Discuss |   Briefcase | 1,041 reads

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 | 628 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 | 33,121 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 | 33,121 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,903 reads
   Items 1 to 6 of 6   
 
Tags
dynamic sql (2)    
alternative to cursors (1)    
counter (1)    
cte (1)    
data integrity (1)    
loop (1)    
maintenance (1)    
system view (1)    
table variables (1)    
tally (1)    
transaction logs (1)    
t-sql (1)    
while (1)    
while loop (1)