SQL Server Reporting Services Question:

Download Job Interview Questions and Answers PDF

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.

Download SSRS Interview Questions And Answers PDF

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