Skip to content

SQL Cursor Example

January 11, 2012
    
 DECLARE @Cursor CURSOR	
 DECLARE /* variables */
   
 SET @Cursor = CURSOR FORWARD_ONLY STATIC FOR
 /* SELECT statement */
    
 OPEN @Cursor
 FETCH NEXT FROM @Cursor INTO  /* variables */
    
 WHILE @@FETCH_STATUS = 0 
    BEGIN


        FETCH NEXT FROM @Cursor INTO  /* variables */
    END
    
 CLOSE @Cursor
 DEALLOCATE @Cursor        
 
Advertisements

From → CodeProject, SQL

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: