While SQL queries can combine table data in complex ways, the result from any SQL query is a rather simple row-and-column arrangement.
虽然SQL查询可以以复杂的方法来组合表数据,但所有SQL查询的结果都是相当简单的“行与列”的排列。
The SQL explain facility provides detailed information about the access plan that the query optimizer chooses for an SQL statement.
SQL解释工具提供查询优化器为 SQL语句所选择的访问计划的有关详细信息。
Case sensitivity is sometimes difficult for SQL programmers to remember, as SQL query syntax permits them to use "zip," "zip," and "zip" to refer to the same column name.
SQL程序员有时候很难记住大小写敏感这一点,因为SQL查询语法允许使用“zip ”、“ zip ”和“ zip ”来引用同一个列名。
All SQL comparisons, SQL query execution, and SQL casting takes place in the database code page.
所有SQL比较、SQL查询执行以及SQL类型转换都必须在数据库代码页中进行。
A SQL injection vulnerability occurs when a user is able to pass SQL code directly to the application in such a way that the code will be executed in a query.
如果用户能够将SQL代码直接传递给应用程序,此代码将在一个查询中执行,那么就可能发生SQL注入攻击。
Even better, prototyping reports with SQL is easy — you run your prototype report, and if the results aren't what you need, you tweak the SQL query or write a new query, and try again.
甚至用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).
SQL编译器使用查询优化来为任何给定的sql语句选择表现最好的访问路径(当然,这要在合理的时间内)。
The only new key in this options array is the SQL key, which defines the inner SQL query to run in order to populate the element.
此选项数组中的惟一新键为sql键,它定义了运行内部sql查询以填充元素。
Note: Any user who is proficient in SQL can type the query directly into the advanced views SQL query text box.
注意:熟悉SQL的用户可以在高级视图SQL文本框中直接输入查询。
Listing 1 gives an example of a SQL query based on a cube model and shows how the parts of the SQL statement map to the elements of the cube model.
清单1给出了一个基于多维数据集模型的SQL查询示例,并展示了sql语句的各个部分如何映射到多维数据集模型中的元素?
If this attribute is present and set to SQL, then the update value (child node of the element) is considered to be an SQL query.
如果这个属性存在并设置为SQL,那么updatevalue(元素的子节点)被视为一个SQL查询。
Convert the attributes and measures into SQL expressions, which are used to construct the SQL statement to query the cube model.
将属性和度量转换为SQL表达式,这些表达式用来构造对多维数据集模型进行查询的sql语句。
The first line of the query issues a SQL SELECT statement that invokes an industry-standard SQL function (XMLQUERY).
查询的第一行发出一个SQLselect语句,其中调用了一个行业标准的SQL函数(XMLQUERY)。
If this attribute is present and set to SQL, then the update value (child node of the element) is considered to be a SQL query.
如果该属性存在并设置为SQL,那么updatevalue(元素的子节点)被视为一个SQL查询。
You can populate every elements array with a separate SQL query, thus allowing for SQL result sets to be nested to an unlimited depth.
您可以使用单独的SQL查询填充每个elements数组,从而允许SQL结果集被嵌入到无限制的深度。
After you enable SQL passthrough, when an SQL query is executed from the application, solidDB tries to search the referred tables in the front-end solidDB database.
启用了SQLpassthrough 后,当从应用程序执行一个 SQL查询时,solidDB试着在前端 solidDB数据库中搜索相关数据表。
The SQL Builder, a GUI tool, is activated by default to assist you in completing the SQL query (refer to Figure 12).
默认情况下,这样做会激活SQLBuilder,这是一个GUI工具,用于辅助完成 SQL查询(参见图 12)。
Once we build an SQL query, we will use the XML From SQL wizard (Figure 2) to generate an XML file with other artifacts, such as a grammar file and default XSL file.
一旦SQL查询创建完毕,我们就将使用XMLFrom SQL向导(图2)带有其他构件(比如语法文件、缺省的XSL文件)的XML文件。
IBATIS doesn't use its own proprietary query language; rather, it relies on standard SQL used within the SQL Maps framework.
iBATIS不使用其专有的查询语言;而是依赖于SQLMaps框架中使用的标准SQL。
The first JSP, Welcome.jsp, occupies both the presentation layer and the data layer by using the JSTL SQL library to issue an SQL query from the page.
第一个JSP,即Welcome.jsp,使用JSTLSQL库从该页面发出一个 SQL查询,因而同时占据了表示层和数据层。
At the moment the query is created, no SQL statement is issued to the database. The SQL statement is created and executed when your code iterates the IQueryable object.
当创建这个查询时,SQL语句并没有被发送到数据库中,只有当你在代码中对这个IQueryable对象进行Iterate操作时,这个SQL语句才会被创建并执行,这个概念就是延迟执行。
The query language of CMIS is a subset of SQL-92 (ISO/IEC 9075: 1992 – Database Language SQL) with a few extensions.
CMIS的查询语言是有一定拓展的SQL-92 (ISO/IEC 9075: 1992 –DatabaseLanguage SQL)的子集。
Depending upon your choice of SQL builder or SQL editor option, the IDE will either open a query builder wizard or an SQL editor to build the required query.
根据您选择的SQLBuilder或SQLEditor选项,IDE将打开一个查询构建器向导或一个SQL编辑器来构建所需的查询。
You cannot express this particular query in pure XQuery (with no SQL) because the data to be returned includes company IDs, which are stored in an SQL integer column.
这个查询不能用纯x Query(不含SQL)表达出来,因为要返回的数据包括公司ID,它存储在一个SQL整数列中。
Note that the SQL Query that you enter is a formula that evaluates to an SQL Query.
注意输入的SQL查询是一个SQL查询公式。
Most developers have heard of a good example of an anti-pattern: The improper use of Structured Query Language (SQL) libraries that result in SQL injection attacks on Web sites.
大多数开发人员听说过关于反模式的一个很好的例子:结构化查询语言(Structured Query Language,SQL)的错误使用导致Web 站点受到 SQL注入攻击。
Launch into Optim Query Tuner (if installed) directly from SQL-related dashboards to do immediate tuning of problematic SQL, closing the loop on performance problem resolution.
直接从SQL相关的面板启动OptimQueryTuner(如果已安装)来快速调整有问题的SQL,结束性能问题解决循环。
For example, if a Query Subject is giving errors, the SQL Statement can be copied and pasted in one of these tools to validate the SQL Statement.
例如,如果QuerySubject出现错误,那么可在这些工具中对sql语句进行复制与粘贴,来验证sql语句。
When you edit the SQL Query View in Domino Designer, a new event, SQL Query, appears in the programmer's pane, as shown in figure 11.
当在DominoDesigner中编辑SQL查询视图时,一个新的事件(SQL Query)将出现在编程窗格中,如图11所示。
The basic optimization methods of the SQL query language is presented by comprehending executive tactics of RDBMS optimizer and analyzing the factors that affect the SQL query languages efficiency.
介绍RDBMS优化器的执行策略和分析了影响SQL查询效率的因素的基础上,提出了优化SQL查询效率的基本方法,以提高数据库查询的执行效率。
应用推荐