Explain the ways to controlling Cursor Behavior?

Submitted by: Administrator
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.
Submitted by: Administrator

Read Online SQL Server Cursors Job Interview Questions And Answers