server cursor 中文意思是什麼
server cursor
解釋
服務端游標-
Sql server creates a static snapshot cursor
Sql server創建了一個靜態快照游標。 -
After for update of. sql server implicitly converts the cursor to another type if clauses in
中的子句與所請求的游標類型的功能有沖突,則sql server會將游標隱式轉換為其他類型。 -
Of a cursor declaration. microsoft sql server implicitly converts the cursor to another type if clauses in
中的子句與所請求的游標類型的功能有沖突,則sql server會將游標隱式轉換為其他類型。 -
In sql server 2000, cursor is converted from to
Sql server 2000中轉換前的游標 -
Updatable result sets always use a server cursor
可更新結果集始終使用服務器游標。 -
Sql server can sometimes choose to implement a cursor type other than the one requested, which is referred to as an implicit cursor conversion or cursor degradation
Sql server有時可以選擇實現一種游標類型,而不使用請求的游標類型,這稱為隱式游標轉換(或游標降級) 。 -
In microsoft sql server 2005, the select statement in a cursor definition is subject to the same transaction locking rules that apply to any other select statement
在microsoft sql server 2005中,游標定義中的select語句遵守適用於任何其他select語句的相同的事務鎖定規則。 -
Sql server will consider parallel execution plans for queries, index data definition language operations, and static and keyset - driven cursor population
Sql server將考慮為查詢、索引數據定義語言( ddl )操作、靜態的和由鍵集驅動的游標填充實施并行執行計劃。 -
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 neither a transact - sql nor api cursor has been requested, sql server defaults to returning a complete result set, known as a default result set, to the application
如果既未請求transact - sql游標也未請求api游標,則默認情況下sql server將向應用程序返回一個完整的結果集,這個結果集稱為默認結果集。 -
The following table lists the implicit cursor conversions that occur in sql server 2000 but do not occur in sql server 2005
下表列出了sql server 2000中會發生而sql server 2005中不會發生的隱式游標轉換。 -
For more information about implicit cursor conversion, see the " using implicit cursor conversions " topic in sql server books online
有關隱式游標轉換的詳細信息,請參閱sql server聯機叢書中的「使用隱式游標轉換」主題。 -
Is the name of the transact - sql server cursor defined
所定義的transact - sql服務器游標的名稱。 -
No server cursor is created
不創建服務器游標。 -
Plan guides can match queries that are submitted from api server cursor routines
計劃指南可以與通過api服務器游標常式所提交的查詢匹配。 -
Inserts made by other users are not visible inserts cannot be made through a transact - sql server cursor
其他用戶執行的插入是不可見的(不能通過transact - sql服務器游標執行插入) 。 -
Or to api server cursor routines ; therefore, they can also be matched by sql or template plan guides
或調用api服務器游標常式;因此,它們也可以通過sql或template計劃指南進行匹配。 -
You can see the invocation of api server cursor routines in sql server profiler traces by viewing the
事件探查器跟蹤事件,可以在sql server事件探查器跟蹤中看到api服務器游標常式的調用。 -
A server cursor that is built to support the cursor functions of an api, such as odbc, ole db, ado, and db - library
由ado . net查詢返回的一種數據流。 datareader對象使客戶端能夠接收只讀、只進的數據流。
分享友人