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

Scripts with tag cursor Rss

Search for any content tagged cursor

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 3 of 3   
 

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,701 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,100 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 | 640 reads
   Items 1 to 3 of 3