SCROLL_LOCK With Cursor in SQL Server

Question

I want to know when we use SCROLL_LOCK with cursor in SQL Server. Thank you.

Satyapriya Nayak · Answer

Hi Vipendra SCROLL_LOCKS - Specifies that cursor will lock the rows as they are read into the cursor to ensure that positioned updates or deletes made through the cursor will be succeed. Please refer the below link http://www.databasejournal.com/features/mssql/article.php/1439731/Using-SQL-Server-Cursors.htm Thanks

Vulpes · Answer

The SCROLL_LOCKS option should be used if you want positioned updates or deletes made through the cursor to be certain to succeed. However you can't use this option in combination with the FAST_FOWARD option.