SQL server capabilities - What are the capabilities of Cursors?

What are the capabilities of Cursors?

- Cursors can support various functionalities that are listed here.
- Cursor allow to position at specific rows of the result set.
- Cursor can retrieve one or more rows in the result set.
- Cursor allows modification to the rows in the result set.

What are the capabilities of Cursors?

Capabilities of cursors:
- Cursor reads every row one by one.
- Cursors can be used to update a set of rows or a single specific row in a resultset
- Cursors can be positioned to specific rows.
- Cursors can be parameterized and hence are flexible.
- Cursors lock row(s) while updating them.
What are the ways to controlling Cursor Behavior?
SQL server Cursor Behavior - Cursors behavior can be controlled by dividing them into cursor types: forward-only, static, keyset-driven, .......
Advantages of using Stored Procedures
SQL server Stored Procedures - Stored procedures provide performance benefits through local storage, precompiling the code, and caching.......
What are the ways to code efficient transactions?
SQL server transactions - We shouldn't allow input from users during a transaction......
Post your comment