DECLARE CURSOR

• 
  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 April 19, 2010 11:43

  - 0 +
• 
  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 March 01, 2012 12:43

  - 0 +
• 
  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.

  datacentricity July 19, 2012 04:02

  - 0 +
• 
  I know this is an old post, but I have taken the liberty to improve it a little. Now you will be prompted for the cursor name, so you dont have to copy/paste it down through the code.
  
  DECLARE $CURSOR$--@Variables
  
  DECLARE <Cursor_Name, varname, Cursor_Name> CURSOR
  FOR /*Select Statement*/
  OPEN <Cursor_Name, varname, Cursor_Name>
  FETCH NEXT FROM <Cursor_Name, varname, Cursor_Name>
  INTO --@Variables
  
  @FETCH_STATUS = 0
  BEGIN
  
  /*SQL Statements*/
  
  FETCH NEXT FROM <Cursor_Name, varname, Cursor_Name>
  INTO --@Variables
  END
  CLOSE <Cursor_Name, varname, Cursor_Name>
  DEALLOCATE <Cursor_Name, varname, Cursor_Name>

  ofrede October 09, 2014 04:24

  - 0 +
• 

  datacentricity wrote:

  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.

  
  I get what you're saying but the point or purpose for creating Code Snippets is so you have quick access to frequently used code, not access to seldom used code. I doubt the author of this thread was creating a snippet for a seldom used cursor

  EdCarden October 16, 2014 13:02

  - 0 +
• 
  Actually, that's precisely why I am looking at this page
  
  

  jac October 08, 2019 22:22

  - 0 +

Add comment

Please sign in to leave a comment.