Enlist the types of cursor?

devquora

devquora

Posted On: Feb 22, 2018

There are two types of Cursor in MSSQL-

Implicit cursor– Implicit cursors are automatically created whenever an SQL statement is executed and this happens without the user’s notice.
Explicit cursor– Explicit cursors are created with the awareness of users. It handles the SQP/PL query in one row and exercises more control over the context area.

Related Questions

Please Login or Register to leave a response.

Never Miss an Articles from us.

Related Questions

What is DBMS?

DBMS (Database Management System) is a computer software application that allows users and other applications to view,..

Enlist various types of interactions created by DBMS ?

There are various kinds of interactions supported by DBMS like- Data definition Update Retrieval Administration..

What are the features of Database language?

Database language is used to create and store data in computer system. DBMS itself is one of the features of database l..