Click here to Skip to main content
Click here to Skip to main content
Alternative Tip

Always close your cursor

, 18 Oct 2011
Rate this:
Please Sign up or sign in to vote.
You also might want to look into the "LOCAL" keyword.This limits the scope of the cursor to the context in which it is created.DECLARE IdCursor CURSOR LOCAL FOR SELECT Id FROM MyTableThis is beneficial for many reasons.
You also might want to look into the "LOCAL" keyword.
This limits the scope of the cursor to the context in which it is created.
 
DECLARE IdCursor CURSOR LOCAL FOR SELECT Id FROM MyTable
 
This is beneficial for many reasons.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Kabwla.Phone
Software Developer (Senior)
Netherlands Netherlands
Doing that 'computer thing' ever since the C64.
 
Sometimes I feel that being a programmer is much like being a doctor: You just have to know everything and if you don't, something dies.
 
Either being an appliction or a patient.
Oddly enough, more people care about the death of their application, than the massacre op people...

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web01 | 2.8.140709.1 | Last Updated 18 Oct 2011
Article Copyright 2011 by Kabwla.Phone
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid