Anil Singh | Code-sample.com

What is a SQL Server Cursor? A SQL Server CURSOR is a set of T-SQL logic to loop over a pre-determined number of rows one at a time and the purpose for the cursor may be to update one row at a time.     OR The major function of a cursor is to retrieve data, one row at a time, from a result set, unlike the SQL commands which operate on all the rows in the result set at one time. Cursors are used when the user needs to update records in a singleton fashion or in a row by row manner, in a database table. SQL Cursor Life Cycle The following steps are involved in a SQL cursor life cycle . 1.      Declare Cursor - A cursor is declared by defining the SQL statement. 2.      Open Cursor-   A cursor is opened for storing data retrieved from the result set. 3.      Fetch Cursor - When a cursor is opened, rows can be fetched from the cursor one by one or in a block to do data manipulation. 4. ...