Typically, the UDF is used in the select list of a SQL query.
通常,这个UDF被用在SQL查询的select列表中。
The parentheses (()) used in the select attribute are essential to correct behavior.
select属性中使用的括号 (())对于正确的行为很重要。
Then select the Create report - Create a Jasper report from a database option from the Jasper item in the select a connector dialog.
然后在Selectaconnector对话框中从Jasper项选择Createreport- Create a Jasper reportfrom adatabase选项。
All of the SQL expressions for any attributes that were selected as columns in the select clause should also be in the GROUP BY clause.
对于作为select子句中的列的任何属性,它们的SQL表达式也应该放在GROUP by子句中。
For stored procedures, you can map the input and output parameters of the stored procedure to the data set source columns as defined in the select command.
对于存储过程,您可以将该存储过程的的输入和输出参数映射到select命令中所定义的数据集源列。
The IDN, or a sub-tree of it, can be in the select expression of xsl:apply-templates, allowing the tree to be processed in the same manner as an XML input document.
IDN或其子树可以出现在xsl:apply-templates的select表达式中,允许按照与XML输入文档相同的方式处理。
If you use XML predicates in the XMLQUERY function in the select clause of an SQL statement, these predicates do not eliminate any rows from the result set and therefore cannot use an index.
如果在sql语句的select子句的XMLQUERY函数中使用xml谓词,则这些谓词不会从结果集中排除任何行,因此不能使用索引。
So to find the row that satisfies the predicate in the select statement, the optimizer has to lock, read in, and compare all the rows in the main table with the value supplied in the predicate.
因此要找到满足select语句中谓词的行,这个优化器必须将主表中的所有行上锁、读取它们的值并与谓词中提供的值进行比较。
The problem is that EMPNO is included in the SELECT-list.
问题是EMPNO已经包含在SELECT列表中。
In the select Ports dialog, select the port on which to send messages.
在SelectPorts对话框中,选择发送消息的端口。
In the select Machine Type panel, select the EIP development workstation option.
在SelectMachineType面板中,请选择EIP developmentworkstation选项。
Both wordform and definition are declared in the SELECT clause, so both are output.
wordform和definition都在SELECT子句中声明,所以它们都是输出。
A literal is a character, a number, or a date that is included in the SELECT statement.
原义字符是在查询语句中包含的一个字符,数字或者是时间数据。
In the Select publish location part of the publish Wizard, click Next to take the defaults.
在publishWizard的Select publishlocation部分,单击Next接受默认值。
In the Select field, click content* and then select Web Content from the list that displays.
在Select字段中,单击content*,然后从显示的列表中选择Web Content。
Add the SQL expressions generated for each of these attributes as columns in the SELECT list.
将这些属性的SQL表达式添加到SELECT列表中作为列。
Scroll down in the Select counters section to select Rows read and Rows selected, as shown in Figure 12.
在Selectcounters部分中向下滚动,找到并选择Rowsread和 Rowsselected,如图 12 所示。
If you click on a table in the FROM clause, it will highlight related columns in the SELECT and WHERE clauses.
如果单击from子句中的表,它会突出显示SELECT和where子句中相关的列。
For the xmlquery function in the SELECT clause, the porder column of the purchaseorder table is passed by default.
对于select子句中的xmlquery函数,默认情况下传递purchaseorder表的porder列。
Select the check box in the Select column for the CallForwardingSample.sar file, and click Start to start the application.
为CallForwardingSample.sar文件选中Select列的复选框,并点击Start以启动应用程序。
In the select page of the New wizard, select Portlet development, and then select Portlet application project on the right.
在New向导的Select页中,请选择Portletdevelopment,然后在右边选择Portletapplicationproject。
Finally, if possible, include all of the columns in the SELECT in the index, so that there is no need to access the table rows.
最后,如果可能的话,将SELECT中所有的列包括到索引当中,这样就不需要访问表中的行。
Row identifier (RID_BIT or RID) built-in function: This built-in function can be used in the SELECT list or predicates statement.
行标识符(RID_BIT或RID)内置函数:该内置函数可用于SELECT列表或谓词语句。
In the Select Directory field, as shown in Figure 14, choose the temporary folder, which is where your exported object is stored.
在SelectDirectory字段中(如图14所示),选择temporary文件夹,它是您存储导出的对象的位置。
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.
第一条规则是始终在每条 SQLSELECT语句的SELECT 列表中只提供 确实需要检索的那些列 。
For each of the measures that are to be in the query, add the SQL expression generated for the measure as a column in the SELECT list.
对于查询中的每个度量,将度量的SQL表达式添加到SELECT列表中作为列。
XMLQUERY is often used in the SELECT clause of an SQL query to extract or construct XML values based on the XML document in a given row of the result set.
在SQL查询的select子句中,常常使用XMLQUERY根据结果集的给定行中的XML文档提取或构造xml值。
Note that an order by clause in the SELECT statement would not have any effect on the order of the array elements, as it would apply to the rows returned by the statement.
请注意,select语句中的ORDERBY子句不会对阵列元素的顺序产生任何影响,因为它将应用于该语句返回的行。
Each matching binding of the graph pattern's variables to the model's nodes becomes a query solution, and the values of the variables named in the SELECT clause become part of the query results.
将每个图形模式变量的绑定与模型节点进行匹配就成为一种查询解决方案,而select子句中指定的变量值则成为查询结果的一部分。
This is a fairly easy mapping that you can do in the annotations simply by using the SQL feature of aliasing the column, which is done in the SQL defined in the @Select annotation.
这个映射相当简单,可以在注释内进行,只要使用为该列赋别名的SQL特性就可以了,这个特性可由在 @Select注释内定义的 SQL完成。
应用推荐