What is Cursor in SQL Server?

A Cursor is a set of rows together with a pointer that identifies a current row. 

In other word, Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis.