What are cursors? Name four types of cursors and when each one would be applied? ?

Question

cursor in SQL server.

explain cursor and why it is used

Answer 1

SQL is basically a set-based query language. When working with a script (as in SQL Server's T-SQL), you often will want to perform specific processing depending upon the values in each row. A cursor is the mechanisim by which the result set of the base query is passed into the script one row at a time for evaluation and processing via the Fetch command.

As for multiple types of cursors, I have no idea what you're referring to here - the only subclassifications of cursors I know of offhand are those that are specified as updatable and those that aren't