What are the ways to controlling Cursor Behavior?

What are the ways to controlling Cursor Behavior?

Cursors behavior can be controlled by dividing them into cursor types: forward-only, static, keyset-driven, and dynamic. SQL server supports keywords SCROLL and INSENSITIVE to define cursor behavior in terms of scrollability and sensitivity.

What are the ways to controlling Cursor Behavior?

There are 2 ways to control Cursor behavior:
- Cursor Types: Data access behavior depends on the type of cursor; forward only, static, keyset-drive and dynamic.
- Cursor behaviors: Keywords such as SCROLL and INSENSITIVE along with the Cursor declaration define scrollability and sensitivity of the cursor.
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......
Differences among batches, stored procedures & triggers
SQL server Batches, stored procedures & triggers - A batch is a group of one or more SQL statements. SQL Server compiles the statements of a batch......
Post your comment

Related Content

Follow us

▲