What do you mean by KEYSET Cursor
Posted on January 12th , 2010 by Admin
|
|
KEYSET Cursor uses the set of keys that are primary key or we can saw uniquely identify the cursor's rows. SQL Server uses a table in tempdb to store keyset. The KEYSET cursor helps to updates non key values from being made through this cursor, but when inserts made by other users are not visible. Updates nonkey values made by other users are visible as the owner scrolls around the cursor, but updates key values made by other users are not visible. |
|
|
