Transact - sql cursors and api cursors have different syntax , but the following general process is used with all sql server cursors Transact - sql游标和api游标有不同的语法,但下列一般进程将用于所有sql server游标:
For a full description of the sql server cursor types , see the " cursor types database engine " topic in sql server books online 有关sql server游标类型的完整说明,请参阅sql server联机丛书中的“游标类型(数据库引擎) ”主题。
Defines the attributes of a transact - sql server cursor , such as its scrolling behavior and the query used to build the result set on which the cursor operates 定义transact - sql服务器游标的属性,例如游标的滚动行为和用于生成游标所操作的结果集的查询。
Declare cursor defines the attributes of a transact - sql server cursor , such as its scrolling behavior and the query used to build the result set on which the cursor operates Declare cursor定义transact - sql服务器游标的属性,例如游标的滚动行为和用于生成游标所操作的结果集的查询。
Sql server 2005 continues to support asynchronous keyset - driven or static api server cursors where low - latency open is a concern because of client roundtrips for each cursor operation Sql server 2005继续支持异步键集驱动的或静态的api服务器游标,但由于每个游标操作的客户端往返,因此需要注意其中的低滞后时间open 。
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是个问题。