SQL Server cursors interview questions

SQL Server cursors - August

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.