![]() Those Inserts will not be visible in already opened cursor. If we insert the rows in source table/s once the cursor is open.This is important as KEYSET Cursor build unique identifiers for the rows by using these unique values. Make sure all of the tables you are using in Select Query has unique index. If your Select query is using any table without Unique Index, the KEYSET cursor is simply going to be converted to Static Cursor.Here are important points to remember about KEYSET Cursor in SQL Server KeySet Cursor create a temp table in TempDB with uniquely built values from the columns which we use in Select statement. When we open Keyset Cursor the membership and order of rows in the cursor is fixed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |