With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.

• READ_ONLY
• SCROLL_LOCK
• OPTIMISTIC
• PESSIMISTIC