What is the real use of Sql cursor ?

Cursor is a database object to retrieve data from a result set one row at a time, instead of the T-SQL commands that operate on all the rows in the result set at one time. We use cursor when we need to update records in a database table in singleton fashion means row by row.

 

Life Cycle of Cursor

 

Declare Cursor

A cursor is declared by defining the SQL statement that returns a result set.

 

Open

A Cursor is opened and populated by executing the SQL statement defined by the cursor.

 

Fetch

When cursor is opened, rows can be fetched from the cursor one by one or in a block to do data manipulation.

 

Close

After data manipulation, we should close the cursor explicitly.

 

Deallocate

Finally, we need to delete the cursor definition and released all the system resources associated with the cursor.