可以使用这些查询定义自己的报告。
清单5.查看者透视图的视图查询定义。
Listing 5. View Query definition for the Viewer perspective.
基于组或搜索查询定义人员查询。
指定要用于创建默认查询的查询定义文件。
Specifies which query definition files to use to create default queries.
这是通过一个涉及服务器、数据库、表和列的SQL查询定义的。
This is defined by an SQL query involving a server, database, table, and columns.
查看者透视图的导航树和视图查询定义分别显示在清单4和5中。
The Navigation Tree and View Query definitions for the Viewer perspective are shown in Listings 4 and 5, respectively.
这导致传递到查询定义的关联EmployeeKey值。
This results in the associated Employee Key value being passed to the query definition.
您可以将命名查询定义为注释,并在代码中的其他位置执行它。
You can define a named query as an annotation and execute it somewhere else in the code. Here is an example of using executing this type of named query.
该查询表达式是一个构建块,可以通过组装它为查询定义最后的选择谓词。
The query expression is a building block that can be assembled to define the final selection predicate for the query.
这个API用于通过创建查询定义对象来定义对检索实体及其状态的查询。
This API is used to define queries for retrieving persistent entities and their state by creating query defining objects.
创建另一个名为“ProductLine”的数据集,并将SQL查询定义如下。
Create another data set called "ProductLine" and define the SQL query as follows.
这样你可以自由的进行方法命名,既可以对查询定义实现完全控制,又不必担心那些查询模板代码。
This gives you freedom in naming methods the way you like while preserving the full control over the query definition without bothering you with the boilerplate query execution code.
你可以在任何一个顶层的SELECT语句以及几乎所有类型的子查询语句前,使用子查询定义子句。
You can specify this clause in any top-level SELECT statement and in most types of subqueries .
创建一个名为DataSet的数据集,该数据集将用于在报告中显示数据,并将该数据集的SQL查询定义如下。
Create a data set called DataSet, which will be used to display data in the report, with an SQL query like this.
其中一个框架用于指定多个SQL查询,每个查询定义一个层,并从DB2数据库中检索空间和非空间数据。
One frame is used to specify multiple SQL queries, where each query defines a single layer and the spatial and non-spatial data is retrieved from your DB2 database.
查询定义了输出文件内容(如果它们有实际值的话),或者在输出文件中复制节点,就像它们在输入文件中发生的一样。
The queries either define the output document content (if they have a textual value), or replicate nodes in the output document as often as they occur in the input document.
创建一个名为“DataSet”的数据集,该数据集将用于显示报告上的数据,并将该数据集的SQL查询定义如下。
Create a data set called "DataSet" which will be used to display data on the report and define the SQL query of the data set as follows.
命名查询是外部化查询的好方法。尽管将命名查询定义为注释可以使查询在代码中得到更多重用,但是优点很少,在本质上没有使用价值。
Although defining a named query as an annotation can make it more reusable in the code, the benefit is so minimal that it is essentially useless.
查询模型定义维度选择、边界、立方体视图以及维度数据的聚合与操纵等概念。
The query model defines the concepts of dimension selections, edges, cube views, and the aggregations and manipulations of dimensional data.
本文仅作简短介绍,因为事件目录本身需要更多的文章来描述用户如何添加、删除和查询事件定义和类型。
This article can only provide a brief introduction as the event catalog would on its own require a further article to describe how users can add, remove, and query event definitions and categories.
然后,管理员把查询表定义部署到服务器上。
The administrator then deploys the query table definition onto the server.
为查看者透视图创建了透视图、导航树、集合视图、详细信息视图和视图查询的定义文件。
The definition files for the perspective, the Navigation Tree, the Collection View, the Detail View, and the View Query were created for the Viewer perspective.
定义查询。
定义流查询语言的标准。
参数化查询要求您定义所有的SQL代码,然后向查询传入每个参数。
Parameterized queries require that you define all the SQL code and then pass in each parameter to the query later.
您无需指定集合或定义查询字符串来加载对象。
You don't need to specify the collection or define a query string to load the object.
查询关系定义业务对象属性值之间的手动填充映射。
A lookup relationship defines a manually populated mapping between business object property values.
在查询中定义业务逻辑和表示逻辑。
You define the business logic and the presentation logic in the queries.
上面的查询可以代替使用XMLTABLE定义视图的查询。
The above query is an alternative to the query with XMLTABLE used to define the view.
查询主题定义看上去应该如图6所示。
Your query subject definition should look similar to Figure 6.
应用推荐