Assertion: cursor | /r/HasProperty | deallocated
Facets:
value: automatically
type: MANNER
value: implicitly
type: MANNER
Source sentences:
text: The cursor is implicitly deallocated when the batch, stored procedure, or trigger terminates, unless the cursor was passed back in an OUTPUT parameter.
text: If it is passed back in an OUTPUT parameter, the cursor is deallocated when the last variable referencing it is deallocated or goes out of scope.
text: After the batch finishes executing, the cursor is automatically deallocated.
text: Therefore, the cursor is deallocated, and not returned to the calling procedure.
text: If a name or variable is the last one referencing the cursor, the cursor is deallocated and any resources used by the cursor are freed.
text: After a cursor name is associated with a cursor, the name cannot be used for another cursor of the same scope (global or local) until this cursor has been deallocated.
text: -- Cursor finally is deallocated when last referencing -- variable goes out of scope at the end of the batch.