static cursor 中文意思是什麼
static cursor
解釋
靜態控制項-
Sql server creates a static snapshot cursor
Sql server創建了一個靜態快照游標。 -
Sql server will consider parallel execution plans for queries, index data definition language operations, and static and keyset - driven cursor population
Sql server將考慮為查詢、索引數據定義語言( ddl )操作、靜態的和由鍵集驅動的游標填充實施并行執行計劃。 -
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
如果由鍵集驅動的游標或動態游標與except或intersect運算一起使用,則運算的結果集的游標轉換為靜態游標。 -
Sql server 2005 continues to support asynchronous keyset - driven or static application programming interface server cursors where low latency open is a concern, due to client round trips for each cursor operation
由於客戶端對每個游標操作都需往返一次,因此sql server 2005將繼續支持異步鍵集驅動游標或靜態應用程序編程介面( api )服務器游標,而在這種情況下低滯后時間的open是個問題。 -
If another cursor type is specified in a recursive cte, the cursor type is converted to static
如果在遞歸cte中指定了其他游標類型,則該類型將轉換為靜態游標類型。 -
Static cursors retrieve the entire result set at the time the cursor is opened
靜態游標在打開游標時檢索整個結果集。 -
Static cursors use a work table to store the complete result set of the cursor
靜態游標使用工作表來存儲游標的完整結果集。 -
The static cursor is either synchronous or a fully populated asynchronous cursor
靜態游標是同步游標或者完全填充的異步游標。 -
If the query references at least one table without a unique index, the keyset cursor is converted to a static cursor
如果查詢引用了至少一個無唯一索引的表,則鍵集游標將轉換為靜態游標。
分享友人