SQL Server Reporting Services Question:
Download Questions PDF

What are the ways to controlling Cursor Behavior?

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?