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

Q

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

✍: Guest

A

Opening a cursor on a result set allows processing the result set one row at a time.
The four API server cursor types supported by SQL Server are:
a) Static cursors
b) Dynamic cursors
c) Forward-only cursors
d) Keyset-driven cursors

2014-10-17, 1530👍, 0💬