在游标定位在行中时,锁定这个被应用程序的某个事务访问的任何一行。
Locks any row accessed by a transaction of an application while the cursor is positioned on the row.
在本例中更适合使用逐字插入,因为这里的目标是精确地复制游标上方的文本。
Verbatim insertion is more appropriate in this example, since the aim is to exactly copy the text above the cursor.
我知道我不能,但对我来说这可能是我的应变方法,因为在本地事务当中,游标具有可保持能力。
I know I cannot, but this could be the workaround for me because, with the local transaction, the cursor will hold ability.
这个人测量了他们的胳膊长度,用游标卡尺检查了他们的眉毛下面的皮肤厚度。
The man had measured the length of their arms, checked with calipers the thickness of the skin below their eyebrows.
默认情况下使用只能前进的游标。
最后,完成时,关闭游标释放资源。
Finally, when you're finished, close the cursor to free up resources.
不支持Sybase游标参数。
这意味着数据库服务器已用尽动态游标。
This means the database server has run out of dynamic cursors.
本地游标引用无明确释放。
应用程序1再次打开游标。
XML游标定义了XML文档中的一个位置。
打开将被返回的游标。
游标模型考虑了不对称和大型结果集的情况。
The cursor model takes into account the cases of asymmetry and large result sets.
使用WITHreturn子句声明游标。
当您移动游标时,是将它移动到符合要求的标志。
When you move a cursor, it moves to the token that fits the description.
以前,这类提取需要游标循环访问字符串的各部分。
Previously this kind of extraction would require cursors iterating over sections of a string.
DataPointer用于作为数据集中的游标。
因此,该字段比其他字段更能显示游标成本。
So it is a much better indicator, along with other fields, of the cost of a cursor.
此外,现在还支持新的布尔、游标、行和数组数据类型。
In addition, new Boolean, cursor, row, and array data types are now supported.
注意,要使用滚动不敏感型游标,必须关闭自动提交功能。
Note that autocommit must be off to use a scroll-insensitive cursor.
而在性能方面,只能前进的游标优于可滚动游标。
In terms of performance, the forward-only cursor is better than the scrollable cursor.
为此,您可以创建滚动不敏感型游标,如 清单4 所示。
To do that, you can create a scroll-insensitive cursor, as seen in Listing 4.
对于只读游标,使用FORREADONLY子句确保游标无歧义。
FOR read-only cursors, make the cursor unambiguous by using the FOR read only clause.
对于每个将要返回的结果集,使用WITHreturn子句声明游标。
Declare cursors for each of the result sets to be returned that specify the WITH return clause.
但某些情况下,您需要游标既能向前又能向后,此时需要使用可滚动游标。
However, in some cases, you will need to read cursors both forward and backward, in which case you should use scrollable cursor.
游标的最简单类型是流水型(firehose)或仅向前型游标。
The simplest type of cursor is the firehose, or forward-only cursor.
不需要通过执行DECLARECURSOR单独定义所需的游标。
Definition of the required cursor does not occur separately by executing DECLARE cursor.
使用PDO::ATTR_CURSOR属性将游标设置为可滚动游标
Set the cursor to be a scrollable cursor using the PDO::ATTR_CURSOR attribute
两类游标都将启用滚动,滚动将使您可以在游标内相对和绝对地向前移动和向后移动。
The two cursors both enable scrolling, which lets you move around within a cursor — forward and reverse, in both a relative and an absolute sense.
注意,对于游标声明,该值为打开游标的次数,不包括该游标取数据的次数。
Note that in case of a cursor declaration the value is the number of times the cursor was opened. It does not include the number of fetches made by the cursor.
应用推荐