For example, you may want to find all customers in Paris and hope to retrieve rows 1, 4, 5, and 7. However, if you search for the value "Paris," only row 7 is returned.
例如,可能希望找到Paris的所有客户,也就是希望获取第1、4、5和7行。但是,如果搜索值“Paris”,那么只会返回第7行。
In fact, the only row-level locking that remains during INSERT is the next-key locks that are required to protect an INSERT from adding keys to repeatable read scanners.
实际上,在INSERT期间惟一保持的行级锁是next - key锁,这个锁用于使INSERT不会添加键到可重复的读扫描器。
A week later, they were asked to sleep for only four hours every night for two nights in a row.
一周后,他们被要求连续两晚每晚只睡四个小时。
For row change timestamp columns only, if the column is defined with the IMPLICITLY HIDDEN attribute, then it is not externalized when there is an implicit reference to the columns of the table.
对于行修改时间戳列(只针对这种列),如果该列使用IMPLICITLYhidden属性定义,那么当对表列进行隐式引用时,不会对该列执行外部化。
Additionally, for each row, we will return a valid XML document containing a root element only.
另外,对于每一行,返回一个有效的XML文档,其中只包含一个根元素。
Since only one row is expected in the result set from this SELECT statement, the table scan here is considered an expensive operation.
因为该select语句的结果集中只期望一行,所以表扫描在这里被认为是代价较高的操作。
This means that if the row size is over (about) 4k, only one row will fit on a page and (about) 4k of space is wasted on the page.
这意味着如果行大小超过(或者接近)4k时,一页只适合一行,这样该页大约有4 k的空间就浪费了。
Eli had four milk shakes in a row, and I only three, but I also suggested a family-size pizza was not enough, and Gabriel Garmendia had to pay for a combo with four extra ingredients.
伊莱要了四个一排的奶昔,我只要了三个,可我还说:一个家庭装的皮萨饼恐怕不够,于是,加布里埃尔·加门迪亚不得不又去买了一个四份一组的拼盘。
Let's say that, using the data instance from Listing 1, we want only one row of data to be presented at a time.
我们可以这样说,使用来自清单1中的数据实例,一次只需要显示一行数据。
The resolver looks at the metadata type on the returned row and column, ensuring it only reads XML columns with the SQLXML type.
这个解析器检查返回的行和列上的元数据类型,以确保它只读取sqlxml类型的xml列。
Thus the estimation for final the result set is one row only (NLJOIN (2)), which matches the real result.
因此结果集中最终的评估值只有一个(NLJOIN(2)),这是符合实际结果的。
Russia's latest row with Georgia is not the only source of anxiety for its neighbours.
让俄罗斯周边国家担心的不仅仅是这次与格鲁吉亚的新冲突。
The only alternative to a lock on every new row is a table lock (since there are no page locks in DB2).
对于每个新行之上的锁,惟一可以替代的是表锁(DB 2中没有页锁)。
When the query selects only [1, 8] characters, Row 1 results in AAA3BBB3CC.
当查询只选择[1,8]字符时,行1生成aaa3bbb3cc。
Row 2 has only English characters containing 10 letters (logical characters) that contain 1 byte each.
行2只有英文字符,包含10个字母(逻辑字符),每个字符包含1字节。
Row only includes accounts with dimensionality.
行只包含有维度的账户。
While RDBMS values can be of different types, a Row contains only one, the string type.
不同于rdbms值可以是不同的类型,Row仅包含一种类型,即字符串类型。
If your intention is a real "between" predicate, then the execution plan on the right is much better, because a single range scan with a start-top predicate delivers the matching row IDs only.
如果您的目的是要实现真正的“between”谓词,则右侧的执行计划会更好一些,因为带有启动谓词的单个范围扫描仅传递匹配的行id。
A table row must fit in only one page; it cannot span to other pages as in Oracle.
表中的一个行只能放在一个页中,而不能像Oracle中那样跨多个页。
Consider Listing 12, which demonstrates by retrieving only the header row of a specified worksheet.
考虑清单12,其中演示了只检索指定工作表的标题行。
For this report run only nulls are being suppressed on both the row and column edge of the crosstab.
对于该报表运行,仅在交叉表的行和列边缘上抑制了nulls。
Softbank's flagship stores look almost comical now, with rows and rows of iPhones broken only by the occasional row of iPads, in a space that used to have a wide array of handsets.
软银的旗舰店如今看上去简直是滑稽,一排排全是iPhone,只是偶然在中间穿插摆放一两排的iPad,以前这里的手机可是种类繁多啊”。
In the normal operation the web service pack will only fetch a single row as output.
在正常的操作中,WebServicePack将仅获取一个行作为输出。
A chimpanzee might not manage a test of this level of complexity, but could, maybe, work out the idea of three-in-a-row when only a single row was involved.
黑猩猩可能没办法理解这种复杂度等级的测验,但当只有一行时,它们也许就可以明白“ 3格- 1行”的概念了。
If only one row is in the APP.CONTACTS table the select output would appear as shown in Figure 17.
如果APP. contacts表中只有一行,该select语句的输出将如清单17所示。
T2zos does not know if the cursor returned from a stored procedure is rowset or not, thus the t2zos driver allows only single row fetch for a stored procedure.
t2zos不知道从存储过程返回的游标是不是一个行集,因此t2zos驱动程序仅允许对存储过程执行单行获取。
Unlike other compression techniques that scan only a portion of each row for repeating patterns, Storage Optimization scans the entire row, regardless of how many columns it intersects.
其他压缩技术只在每行的一部分中寻找重复模式,而StorageOptimization会扫描整个行,无论行中有多少列。
If you need only to compute the distance and not alignments, as is usually the case, it is easy to reduce this to o (n), since only the previous row is required to compute the next.
如果您只需要计算距离,不需要校准,就像通常情况那样,那么可以很容易地把空间需求降到O (n),因为计算下一行只需要前面一行。
If you need only to compute the distance and not alignments, as is usually the case, it is easy to reduce this to o (n), since only the previous row is required to compute the next.
如果您只需要计算距离,不需要校准,就像通常情况那样,那么可以很容易地把空间需求降到O (n),因为计算下一行只需要前面一行。
应用推荐