SQL Server Reporting Services Question:

What are the ways to controlling Cursor Behavior?

SSRS Interview Question
SSRS Interview Question

Answer:

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.


Previous QuestionNext Question
Define Truncate and Delete commands?Define Identity and uniqueidentifier property of Column?