What is cursors?

What is cursors?
Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis,
instead of the typical SQL commands that operate on all the rows in the set at one time.

In order to work with a cursor we need to perform some steps in the following order:
Declare cursor
Open cursor
Fetch row from the cursor
Process fetched row
Close cursor
Deallocate cursor

Comments

Popular posts from this blog

What is the use of DBCC commands?

Google to FTS Syntax Cheat Sheet

What is difference between DELETE and TRUNCATE commands?