This method is used to implement a trace facility for the VTI purpose functions invoked during a simple select SQL statement.
该方法用于在简单的SQL选择语句期间为调用的vti目的函数实现一个跟踪功能。
To set the default data base connection, select SQL Database Connections and check the selections as shown in Figure 4.
要设置缺省数据库连接,请选择SQLDatabaseConnections并检查如图4所示的选择。
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。
Edit SQL default select conditions.
编辑sql缺省选择条件。
This paper introduces the basic query format and the applications of SELECT-SQL statement in the query, programming and statistical analysis of library's management.
介绍了查询语句的基本格式以及SELECT—SQL语句在图书馆管理的查询、编程、统计分析中的应用。
The above query elements property table would produce the following SQL select query.
上面的查询元素属性表应该生成以下SQL选择查询。
Because both of these views are defined with a single SQL select statement on the underlying table, the query performance will not suffer.
因为这两个视图都是在下面的表格上使用单独的SQL选择语句进行定义,所以不会影响查询性能。
This function takes a string value as input which is a valid SQL full select statement.
此函数将一个字符串值作为输入,该字符串是一个有效的SQL全选择语句。
An SQL select statement that will be executed to retrieve several rows from the database.
一个SQL选择语句,它从数据库中获取几行。
The second SQL select creates rows for the "Has_name" predicate, which connects person instances to their name strings.
第二个SQL选择语句为“Has_name”谓词创建行,它将人实例与他们的名字字符串联系起来。
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 update does not use an SQL WHERE clause to select a specific row.
这个更新并不使用SQLwhere子句选择特定的一行。
From the "Enter an SQL query" window, select one or more tables of your choice.
在“Enteran SQLquery”窗口中,选择一个或多个表。
The query string contains a simple SQL statement to select all contact information for a specific client.
query字符串包含一个简单的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。
Filter: this field is an SQL statement used to select rows from this table.
Filter:这个字段是一个用于从该表选择行的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语句选择表现最好的访问路径(当然,这要在合理的时间内)。
In our example, plain SQL is not sufficient to select only department PR27 and only return the employee names.
在我们的示例中,普通SQL不足以实现仅选择部门PR27且仅返回员工姓名这项任务。
In addition, it is not a good idea to select partitioning keys based on a handful of SQL statements.
此外,基于为数不多的sql语句选择分区键也不是一个好的做法。
The Select annotation in the AutomobileMapper interface maps the selectAutomobile method to the SQL that can be used to select a record from the automobiles table with the given value.
AutomobileMapper接口内的 Select注释将selectAutomobile方法映射到用来根据给定值从automobiles表选择一个记录的SQL。
They use the SQL/XML predicate XMLEXISTS to select XML documents based on one or multiple conditions which are expressed in XQuery notation.
它们使用SQL/XML谓词XMLEXISTS根据一个或多个条件选择 XML文档,条件用XQuery表示法表示。
When you select a recommendation, the line of SQL is highlighted, and you are presented with a description of how to rewrite the query, as well as an explanation of the recommendation (see Figure 1).
当选择一个建议时,突出显示sql行,显示对如何重写查询的说明以及对建议的解释(见图1)。
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.
语句从数据源选择记录时,通常会得到一个结果集,即一组来自表或查询的记录。
In the Choose Data Source dialog, select Microsoft SQL Server as Data Source and click Continue.
在选择数据库对话框中,选择MicrosoftSQLServer作为数据源,然后点继续。
Selecting HPL query brings up a small SQL select statement panel that shows a select query for the table in use.
选择HPLquery将弹出一个小的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语句。
Identify the rows and columns to select from Informix and execute an SQL select to retrieve the data.
确定从Informix选择的行和列,并执行一条SQL select语句,以检索数据。
It can be used in the WHERE clause of an SQL statement to select only the rows that return non-trivial XML values for the XPath expression.
可以在sql语句的where子句中使用它只选择那些对于XPath表达式返回非空xml值的行。
Prepare an SQL-prepared statement to select a row of data for the catalog id value input in the form.
准备一个SQL预置语句,该sql语句从catalog表中选择与表单中输入的catalogid值对应的一行。
应用推荐