FOR update clause to obtain an update lock.
FORupdate子句来获取更新锁定。
Notice the second clause to the for expression in Listing 12?
注意到清单12中for表达式的第二个子句了吗?
You simply add the appropriate WHERE clause to the SQL query.
只需将合适的where子句添加到SQL查询中即可。
This update does not use an SQL WHERE clause to select a specific row.
这个更新并不使用SQLwhere子句选择特定的一行。
Add a WHERE clause to limit the number of rows to test the movement of data.
添加where子句以限制转移的数据行数。
XMLAGG functions use the ORDER BY clause to sort the elements within the group.
xmlagg函数使用ORDERBY子句对组内元素进行排序。
The resulting WHERE clause to count a segment that is intersected is the following.
计算一个相交的线段的结果where子句如下所示。
Complication Russia appears to be using this clause to extend its operations in Georgia.
俄罗斯似乎要用这一条款来延续在格鲁吉亚的行动。
You can run parallel import sessions, if you add the ALLOW WRITE ACCESS clause to each import command.
如果将ALLOWWRITEACCESS子句添加到每个导入命令中,则可以运行并行导入会话。
Update 3 also USES a second parameter marker in the WHERE clause to select the row that is updated.
更新3在where子句中使用第二个参数标志来选择要更新的行。
Just create the indexes and add the where clause to your SQL select statements, and you are good to go.
只需创建索引并在SQLselect语句中添加where子句,就会使用索引。
Deterministic function calls can be extracted from the WHERE clause to avoid unnecessary table scan.
可以从WHERE子句中提取确定性函数调用,避免不必要的表扫描。
Use the WHERE clause to filter data in the SQL instead of bringing it all into your program to filter.
在SQL中使用where子句过滤数据,而不是在程序中到处使用它进行过滤。
There is an escape clause to avoid penalties if Europe faces a general shock such as the financial crisis.
如果欧洲面临着像金融危机这样的普遍性打击,那他们就有了逃避惩罚的理由。
In the meantime, you also should try to add extra predicates into your WHERE clause to match other WHERE clauses.
与此同时,还可以尝试向WHERE子句中添加额外的谓语来匹配其他WHERE子句。
Edit the generated SQL script adding the COMPRESS YES clause to the CREATE table statement for the noted fact tables.
编辑生成的sql脚本,对于标记的事实表添加COMPRESSyes子句到CREATEtable语句。
In addition to the let and return clauses, Zorba supports for sequences, as well as the for clause to process them.
除了let和return子句之外,Zorba还支持序列和处理序列的for子句。
For example, you can add a ROWNUM clause to limit the number of rows in Oracle or use the TOP clause for SQL Server.
例如,在Oracle中可以添加rownum子句以限制行数,对于SQLServer使用top子句。
The pseudo column LEVEL can be used in the ORDER BY clause to return the result set in search breadth first sequence.
可在ORDERBY 子句中使用伪列LEVEL按照搜索宽度优先顺序返回结果集。
Before we wrap up everything, I'd like to add a clause to the contract. I'm not comfortable with the verbal agreement.
在我们结束谈判之前我想在合同里加一个条款,我对口头约定不放心。
New for SQL Server 2008, permit you to add a WHERE clause to an index, thus focusing the index on the most important rows.
这是SQLServer 2008的新特性,它使我们可以向索引增加WHERE子句,这样就可以将索引聚焦到大多数重要的行上。
To do so, modify the previous query by adding another predicate to the WHERE clause to test for missing email information.
为此可以修改之前的查询,添加另一个谓词到WHERE中,以测试是否缺少email信息。
You can use the in clause to create an index in the same table space where user data resides, or in a different table space.
您可以使用in子句在用户数据所在的表空间上创建一个索引,或者在其他表空间上创建索引。
He convinced Congress to add a clause to its "Buy American" effort promising Washington would meet its international obligations.
他说服国会在“买美货”的议案里加一条条款以保证华盛顿方面承担其相应的国际责任。
Let's add a WHERE clause to that SELECT statement by invoking the EDIT command and specifying statement number 2 in the sequence.
我们将调用EDIT命令,并在顺序中指定语句序号2,通过这些操作给上面的select语句添加where子句。
In the next example, the previous query is modified, by adding an ORDER by siblings clause to get the siblings in the result sorted by NAME.
在下一个示例中,会修改以前的查询,添加一个ORDERBYsiblings子句,从按照NAME排序的结果中获取同级查询结果。
The library shall notify the Director of the Institute of Museum and Library Services of the applicability of that clause to the library.
上述图书馆应当将上述条目适用于其的情形,报告博物馆和图书馆服务研究院院长。
To achieve this clustering, add the following clause to the second CREATE TABLE statement in Listing 3: ORGANIZE BY DIMENSIONS (label_comp_id).
为了实现这种集群,在清单3中的第二个CREATEtable语句添加如下子句:organizeBYDIMENSIONS (label_comp _ id)。
The query uses a WHERE clause to filter the contents of the weather.bylocation table and retrieve a weather forecast for the specified zip code.
该查询使用WHERE 子句来筛选weather.bylocation表的内容并检索指定邮政编码的天气预报。
Listing 7 defines a sequence of names, and then USES a for clause to loop through this sequence, retrieving each name and adding it to a node collection.
清单7定义一个序列名,然后使用一个for子句遍历该序列,获取每个名称并将其添加到节点集合中。
应用推荐