For dynamic cursors , updated rows will retain their position within the fetch buffer until the window that is defined by the fetch buffer is left 對于動(dòng)態(tài)游標(biāo),更新行將保留這些行在提取緩沖區(qū)中的位置,直到離開提取緩沖區(qū)所定義的窗口。
If a keyset - driven or dynamic cursor is used together with an except or intersect operation , the cursor of the result set of the operation is converted to a static cursor 如果由鍵集驅(qū)動(dòng)的游標(biāo)或動(dòng)態(tài)游標(biāo)與except或intersect運(yùn)算一起使用,則運(yùn)算的結(jié)果集的游標(biāo)轉(zhuǎn)換為靜態(tài)游標(biāo)。
In sql server 2005 , when a dynamic cursor is declared over a table with no unique indexes , and a row is deleted outside the cursor , a subsequent refresh of the cursor retrieves a placeholder for the row with null data 在sql server 2005中,如果對沒有唯一索引的表聲明動(dòng)態(tài)游標(biāo)并在游標(biāo)外刪除行,則隨后對游標(biāo)的刷新會(huì)檢索包含null數(shù)據(jù)的行的占位符。