SQL Server cursors - August 29, 2008 at 18:00 PM by Amit Satpute
What are Global and Local cursors?
Local cursors are available only in the batch, stored procedure, or trigger in
which they were created. They are implicitly deallocated when the batch, stored
procedure, or trigger terminates.
Global cursors are global to the connection.They are implicitly deallocated at
disconnect.
|