Database - SQL Server 2000 - Discussion
Discussion Forum : SQL Server 2000 - General Questions (Q.No. 11)
11.
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
Discussion:
2 comments Page 1 of 1.
Baxy said:
9 years ago
SCROLL_LOCK : This will lock the rows as they are read into the cursor.
READ_ONLY : specifies the rows cannot be updated.
OPTIMISTIC : It will not lock the rows as they are read into the cursor.
READ_ONLY : specifies the rows cannot be updated.
OPTIMISTIC : It will not lock the rows as they are read into the cursor.
Sathish said:
10 years ago
Can I get any explanations?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers