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.
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 application or a patient.
Oddly enough, more people care about the death of their application, than the massacre of people...