Repeat steps 1 and 2, but select SQL STMT throughput, as shown in Figure 9.
重复步骤1和2,但是选择SQLstmt throughput,如图9所示。
If he/she doesn’t, you win; otherwise you still need extra N loading select SQL statements.
如果他/她没有访问,那么你赢了;否则你仍然需要额外的N次select SQL语句。
Set the name of the procedure to "ASSOC_PROC" and select SQL as the language of the procedure.
将过程的名称设为“ASSOC _ PROC”并选中SQL作为此过程的语言。
To set the default data base connection, select SQL Database Connections and check the selections as shown in Figure 4.
要设置缺省数据库连接,请选择SQLDatabaseConnections并检查如图4所示的选择。
This method is used to implement a trace facility for the VTI purpose functions invoked during a simple select SQL statement.
该方法用于在简单的SQL选择语句期间为调用的vti目的函数实现一个跟踪功能。
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 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选择语句提供了足够的细节,该语句将对指定数据源的节点执行。
This function takes a string value as input which is a valid SQL full select statement.
此函数将一个字符串值作为输入,该字符串是一个有效的SQL全选择语句。
SQL default select conditions are stored in the declaration of an SQL record.
sql缺省选择条件被存储在SQL记录的声明中。
Right click in the editor area, and from the context menu select Retrieve SQL.
用鼠标右键单击编辑器区域,从上下文菜单中选择Retrieve SQL。
The above query elements property table would produce the following SQL select query.
上面的查询元素属性表应该生成以下SQL选择查询。
The second SQL select creates rows for the "Has_name" predicate, which connects person instances to their name strings.
第二个SQL选择语句为“Has_name”谓词创建行,它将人实例与他们的名字字符串联系起来。
Edit SQL default select conditions.
编辑sql缺省选择条件。
An SQL select statement that will be executed to retrieve several rows from the database.
一个SQL选择语句,它从数据库中获取几行。
For this example select Generate all SQL statements.
对于这个例子,选择GenerateallSQLstatements。
Generate the DDL (right-click and select Generate DDL as shown in Figure 24), and then select Run SQL on the result script against a database connection.
生成ddl(右击并选择Generate ddl如图24所示),然后在数据库连接上的结果脚本上选择RunSQL。
Identify the rows and columns to select from Informix and execute an SQL select to retrieve the data.
确定从Informix选择的行和列,并执行一条SQL select语句,以检索数据。
You can use standard SQL SELECT statements on both message data and database tables.
您可以在消息数据和数据库表上使用标准的SQL SELECT语句。
Select the SQL Server hostname \ instance name.
选择SQL服务器主机名\实例名。
Imagine running a SQL SELECT statement and merging the results directly into an HTML table marked up to your specifications.
想象一下,运行一个SQL select语句,并将结果直接合并到一个符合自己的规范的HTML表格中。
Do you remember how to restrict SQL SELECT statements to return only rows for customers living in zip code 95116?
还记得怎样限制SQL select语句,使之仅返回居住在邮政编码为95116的地区的客户的行吗?
Using a series of simple examples, this tutorial illustrates how to retrieve data from an IBM DB2 database with standard SQL SELECT statements.
本教程通过一系列简单的例子,阐释如何用标准SQL SELECT 语句检索IBMDB2数据库中的数据。
Select the SQL server instance given to you by your database administrator, in this format: hostname \ instance name.
选择数据库管理员向您提供的SQL服务器,格式为:主机名\实例名。
Just like any other built-in function, table functions can be used in a SQL SELECT statement.
就像其他的内建函数一样,表函数也可以在SQL select语句中使用。
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 列表中只提供 确实需要检索的那些列 。
Important: the Select statement of the SQL Query formula must include all the fields referenced in the view's columns.
重点:SQL查询公式的选择语句必须包括视图列中引用的全部字段。
We will see a little later how to work with SQL SELECT query and the result set using the FESI database access extension.
我们不久后将看到如何使用SQL SELECT查询及运用FESI数据库访问扩展名的结果集。
Be familiar with the basics of the SQL SELECT statement, which was discussed in the fifth article in this series.
熟悉SQL select语句的基础知识,本系列的第五篇文章有介绍。
The queries are standard SQL select statements that operate against the PWH tables.
这些查询是标准的SQL select语句,它们基于pwh表执行。
So the N extra SQL select statements on pojoB were cut down to N/10.
因此N次额外的关于pojoB的select SQL语句被减少到了N/10次。
应用推荐