InSQL procedures, a cursor makes it possible to define a result set (a set of data rows) and performs complex logic on a row by row basis. By using the same mechanics, an SQL procedure can also define a result set and return it directly to the caller of the SQL procedure or to a client application.

A cursor can be viewed as a pointer to one row in a set of rows. The cursor can only reference one row at a time but can move to other rows of the result set as needed.

To use cursors in SQL procedures, you need to do the following:


  • Declares a cursor that defines a result set.
  • Open the cursor to establish the result set.
  • Fetch the data into local variables as needed from the cursor, one row at a time.
  • Close the cursor when done.
Please check this link for detailed information

https://www.mindstick.com/Articles/428/implementing-concept-of-cursor-in-sql-server 

Leave Comment