DECLARE CURSOR

Share your SQL code snippets for SQL Prompt!

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

DECLARE CURSOR

Postby aorozco » Mon Apr 19, 2010 3:54 pm

Hi, I was looking for a DECLARE CURSOR snippet but I couldn't find one, so I decided to create this basic one.

DECLARE $CURSOR$--@Variables

DECLARE /*Cursor name*/ CURSOR
FOR /*Select Statement*/
OPEN /*Cursor Name*/
FETCH NEXT FROM /*Cursor Name*/
INTO --@Variables

WHILE @@FETCH_STATUS = 0
BEGIN

/*SQL Statements*/

FETCH NEXT FROM /*Cursor Name*/
INTO --@Variables
END
CLOSE /*Cursor Name*/
DEALLOCATE /*Cursor Name*/

I hope it helps!
Last edited by aorozco on Mon Apr 19, 2010 5:02 pm, edited 1 time in total.
aorozco
 
Posts: 1
Joined: Mon Apr 19, 2010 3:45 pm
Location: Canada

Postby Giggles220 » Mon Apr 19, 2010 4:43 pm

Thanks, no matter how many times I need to write cursor code, I always cut and paste an example to make sure I get it all. This snippet will be very helpful.
Giggles220
 
Posts: 114
Joined: Thu Dec 07, 2006 9:06 pm
Location: Albany, NY

A Cursor Code Snippet?

Postby EdCarden » Thu Mar 01, 2012 6:43 pm

DO you use cursors enough that you would benefit from having a Cursor code snippet in SQL Prompt?

Cursors are a necessary evil in SQL that more often then ot are heavily over used by traditional procedural/OOP developers. There are valid scenarios for using cursors but they are far and few. If your using cursors enough that having a predefined code snippet would be of benefit then you should look take some time to look at alternatives to cursor use.

BTW - I mean no offense with the above; just comenting on how you could help yourself improve things by avoiding excess cursor use.
EdCarden
 
Posts: 90
Joined: Tue Nov 25, 2008 6:26 pm

Postby datacentricity » Thu Jul 19, 2012 9:02 am

An alternative view might be that if one uses cursors so rarely as to need a snippit to remeber all the correct syntax that's a good thing.
\"Your mind is like a parachute, it works best when open\" Frank Zappa
\"Be wary of strong drink. It can make you shoot at tax collectors…and miss\" Robert Heinlein
blog: http://datacentricity.net
twitter: @datacentricity
datacentricity
 
Posts: 19
Joined: Wed Jul 18, 2012 12:22 pm
Location: London


Return to SQL Prompt code snippets

Who is online

Users browsing this forum: No registered users and 0 guests