SQL Server Cursors Question:
Can you explain the disadvantages/limitation of the cursor?
Answer:
Cursor requires a network roundtrip each time it fetches a record, thus consume network resources.
While data processing, it issues locks on part of the table, or on the whole table.
While data processing, it issues locks on part of the table, or on the whole table.
| Previous Question | Next Question |
| What is Explicit cursors? | Explain the disadvantages of cursors? |