单个选择语句生成,联接被推到数据库。
A single select statement is generated and the join is pushed to the database.
创建GetAllBooks选择语句。
第一个选择语句将人和文档联系起来。
一个SQL选择语句,它从数据库中获取几行。
An SQL select statement that will be executed to retrieve several rows from the database.
它使来自所有选择语句的数据作为单个流显示到视图。
It makes the data from all the Select statements appear as a single stream to the view.
选择语句。
UNIONALL是将所有选择语句连接起来的关键字。
UNION ALL is a keyword that concatenates all the Select statements.
当您打开视图时,状态栏将显示创建的整条选择语句。
When you open the view, the status bar shows the entire Select statement that you created.
重点:SQL查询公式的选择语句必须包括视图列中引用的全部字段。
Important: the Select statement of the SQL Query formula must include all the fields referenced in the view's columns.
在这个示例中,这由最外层的选择语句表示,这个语句将S1用作子查询。
In the example, this is represented by the outermost select statement, which USES S1 as a subquery.
此函数将一个字符串值作为输入,该字符串是一个有效的SQL全选择语句。
This function takes a string value as input which is a valid SQL full select statement.
旧版本的重分发实用程序通过子选择语句使用特殊的insert和delete。
The old version of the redistribute utility USES special insert and delete with sub-select statements.
该方法用于在简单的SQL选择语句期间为调用的vti目的函数实现一个跟踪功能。
This method is used to implement a trace facility for the VTI purpose functions invoked during a simple select SQL statement.
对于每一组具有相同数量和维次序的聚合的度量,需要用单独的选择语句来正确地计算。
A separate select statement will be needed to properly calculate each set of measures that share the same number and dimensional order of aggregations.
因为这两个视图都是在下面的表格上使用单独的SQL选择语句进行定义,所以不会影响查询性能。
Because both of these views are defined with a single SQL select statement on the underlying table, the query performance will not suffer.
选择HPLquery将弹出一个小的SQL选择语句面板,此面板显示正在使用的表的选择查询。
Selecting HPL query brings up a small SQL select statement panel that shows a select query for the table in use.
第二个SQL选择语句为“Has_name”谓词创建行,它将人实例与他们的名字字符串联系起来。
The second SQL select creates rows for the "Has_name" predicate, which connects person instances to their name strings.
两个行中包含的信息为生成完整的SQL选择语句提供了足够的细节,该语句将对指定数据源的节点执行。
The information in both rows provides enough detail to generate a well formed SQL select statement, which will be executed against the nodes specified data source.
这里介绍几种REBOL中的选择语句,这些方法提供了一个按照关键值运行多种分支的方法。
There are several methods to selectively evaluate expressions in REBOL. These methods provide a way for evaluation to branch many different ways, based on a key value.
在生成的第一个选择语句中,把表名改为无效的值(这个示例把PROJECT表改为PROJECT1)。
In the first select statement that was generated, change the name of the table to an invalid value. (This example changes PROJECT table to PROJECT1.)
关键在于使用XMLQUERY保留字表明要通过SQL选择语句执行针对传入XML文档的XQuery。
The key is using the XMLQUERY reserved word to indicate an XQuery that is executed against an XML document that is passed in via the SQL select statement.
在生成的第一个选择语句中,把两个列名改为无效的值(这个示例把PROJNAME和PRENDATE改为无效的值)。
In the first select statement that was generated, change the names of two columns to invalid values. (This example changes PROJNAME and PRENDATE to invalid values.)
现在,当同一个查询运行时,生成的原生sQL是单个选择语句,在语句在数据库层联接来自不同目录的两个表,如图10所示。
Now, when the same query is run, the native SQL that is generated is a single select statement joining the two tables from the different catalogs at the database tier as shown in Illustration 10.
DB 2所做的就是允许UPDATE、DELETE和INSERT出现在选择语句的from子句中,并允许用户选择应该从哪个过渡表进行选择。
All that DB2 does is to allow an UPDATE, DELETE, and INSERT to appear in the from clause of a select and allow the user to chose which transition table shall be selected from.
此外,基于为数不多的sql语句选择分区键也不是一个好的做法。
In addition, it is not a good idea to select partitioning keys based on a handful of SQL statements.
因为已经选择关闭编辑器时保存更改,所以更新的语句会出现在交互clp提示符之后,我们可以选择立即执行该语句。
Because we have chosen to save our changes when closing the editor, the updated statement appears after the interactive CLP prompt, and we have the option of executing the statement immediately.
接受默认的语句类型(SELECT)并选择使用SQL构建器。
Accept the default for the statement type (SELECT) and elect to use the SQL builder.
SQL编译器使用查询优化来为任何给定的sql语句选择表现最好的访问路径(当然,这要在合理的时间内)。
The SQL compiler USES query optimization to select the best performing access path for any given SQL statement (within a reasonable amount of time, of course).
在这个例子中,我们选择修改CREATEprocedure语句而不是修改源代码。
In this example, we have chosen to fix the CREATE PROCEDURE statement instead of modifying the source code.
选择一个语句可在底部显示该语句的执行细节。
Selecting a statement shows in the lower section the execution details of this statement.
应用推荐