The second method is to use something similar to an SQL SELECT statement.
第二种方法是使用某种类似于SQL SELECT 语句的东西。
Next, create a simple SQL select statement that returns an employee record.
接下来,创建一个简单的SQL select语句,该语句返回一个雇员记录。
Note: This is the equivalent to adding a where clause in a SQL SELECT statement.
注意:这相当于在SQL select语句中增加一个where子句。
Think of this function as the equivalent to an SQL SELECT statement with a WHERE clause.
可以把这个函数看作相当于带WHERE 子句的SQL SELECT语句。
An SQL select statement that will be executed to retrieve several rows from the database.
一个SQL选择语句,它从数据库中获取几行。
Just like any other built-in function, table functions can be used in a SQL SELECT statement.
就像其他的内建函数一样,表函数也可以在SQL select语句中使用。
For example, an SQL SELECT statement could use a parameter to define the criteria of a WHERE clause.
举例来说,SQL SELECT语句可以使用一个参数来定义一个WHERE条款规则。
Selecting HPL query brings up a small SQL select statement panel that shows a select query for the table in use.
选择HPLquery将弹出一个小的SQL选择语句面板,此面板显示正在使用的表的选择查询。
Be familiar with the basics of the SQL SELECT statement, which was discussed in the fifth article in this series.
熟悉SQL select语句的基础知识,本系列的第五篇文章有介绍。
The first line of the query issues a SQL SELECT statement that invokes an industry-standard SQL function (XMLQUERY).
查询的第一行发出一个SQL select语句,其中调用了一个行业标准的SQL函数(XMLQUERY)。
The row specifying the column is used to populate the select, FROM and ORDER BY clauses of the SQL select statement.
指定列的行用来组成SQL select语句的select、FROM和ORDERBY子句。
Imagine running a SQL SELECT statement and merging the results directly into an HTML table marked up to your specifications.
想象一下,运行一个SQL select语句,并将结果直接合并到一个符合自己的规范的HTML表格中。
Update 2 is an SQL SELECT statement with the same XMLQUERY function, transform expression, and WHERE clause, as in Update 1.
更新2是一个SQL select语句,其中包含与更新1相同的XMLQUERY函数、转换表达式和where子句。
As a result, the DB2 update lock for the row is released and this row is found by the next SQL select statement in Listing 2.
因此,会释放这一行的DB2更新锁,清单2中的下一个SQL select语句会看到这一行。
Each data source is then read by a simple SQL SELECT statement, and the join is completed within the InfoSphere DataStage process.
只通过简单的SQL select语句对每个数据源进行读取,并且在InfoSphereDataStage流程之内完成连接。
The first rule is to always provide only the exact columns that you need to retrieve in the SELECT-list of each SQL SELECT statement.
第一条规则是始终在每条 SQL SELECT语句的SELECT 列表中只提供 确实需要检索的那些列 。
Because both of these views are defined with a single SQL select statement on the underlying table, the query performance will not suffer.
因为这两个视图都是在下面的表格上使用单独的SQL选择语句进行定义,所以不会影响查询性能。
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.
关键在于使用XMLQUERY保留字表明要通过SQL选择语句执行针对传入XML文档的XQuery。
Normally when you select records from a data source using a SQL SELECT statement, you get a result set, which is a set of records from a table or a query.
语句从数据源选择记录时,通常会得到一个结果集,即一组来自表或查询的记录。
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.
两个行中包含的信息为生成完整的SQL选择语句提供了足够的细节,该语句将对指定数据源的节点执行。
Together information contained in both rows provides enough detail to generate a well formed SQL select statement, which will be executed against the nodes specified data source.
加在一起,两个行中包含的信息为生成完整的SQL select语句提供了足够的细节,该语句将对指定数据源的节点执行。
Again an SQL select statement can be built up according to one or more predicates (possibly established from primary keys in the incoming message, as identified by XPath expressions).
同样,可以根据一个或多个谓语构建SQL select语句(根据XPath表达式的确认,还可以根据传入消息的主键建立)。
Besides specifying the format of the data that is to be written to the output file, you must also provide the name of that file, and an SQL SELECT statement to specify the data that is to be exported.
除了要指定写到输出文件中的数据格式之外,还必须提供该文件的名称和一个用于指定输出数据的SQL SELECT语句。
More investigation is needed to isolate the SQL statement(s), which causes the high read/select ratio.
需要更多的调查以分离SQL语句,这导致较高的读取/选择比率。
This method is used to implement a trace facility for the VTI purpose functions invoked during a simple select SQL statement.
该方法用于在简单的SQL选择语句期间为调用的vti目的函数实现一个跟踪功能。
This function takes a string value as input which is a valid SQL full select statement.
此函数将一个字符串值作为输入,该字符串是一个有效的SQL全选择语句。
The following SELECT statement will return any SQL tables or physical files that have some allocation on SSD in schema (library) MJATST.
下面的select语句将返回MJATST模式(库)中在SSD上有一些分配的任意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).
SQL编译器使用查询优化来为任何给定的sql语句选择表现最好的访问路径(当然,这要在合理的时间内)。
Important: the Select statement of the SQL Query formula must include all the fields referenced in the view's columns.
重点:SQL查询公式的选择语句必须包括视图列中引用的全部字段。
In the final page of the wizard (see Figure 8), you can optionally select different flavors of SQL statement (s) to be generated.
在该向导的最后一个页面中(见图8),可以选择生成不同风格的sql语句。
应用推荐