常常需要将对XML数据的查询限制在特定的名称空间内。
Often, you may need to restrict queries of XML data to specific namespaces.
您可以查看配置结果集的查询限制,以得到关于结果设置界限的更多信息。
For more information about result set limitations, see Configuring query limits on result sets.
可以通过使用Boolean AND操作符将这两个查询限制组合在该查询中。
These two query restrictions are combined in this query by using the Boolean AND operator.
根据用户提交的搜索参数,使用迭代方式构建查询,并将查询限制到那些可以在当前日期内有效显示的已批准清单。
Construct this query iteratively, depending on the search parameters submitted by the user, and restrict it to only those approved listings that are valid for display on the current date.
因为API将每个数据查询限制为1000条结果,所以导出数据必须在比30秒处理超时限制所允许的还要小的块中进行管理。
Because the API limits each data query to 1,000 results, the export data must be managed in even smaller chunks than the 30-second processing timeout constraint allows.
DB 2优化程序使用这些特征和限制来确定处理一个查询的最佳方法。
The DB2 optimizer USES these characteristics and restrictions when determining the best way to process a query.
您可以将查询的输出仅限制为特定字段。
You can restrict the output of the query to specific fields only.
您可能很想知道如何在应用程序中包括限制XML数据的查询。
You may be curious how to include a query that restricts XML data in an application.
在图3中是我们的第三个例子,其中,查询结果被限制在头n个元素。
In Figure 3, our third example is where the query result is limited to top-N elements.
在select语句中使用视图,可以限制表的连接顺序,同时也限制查询优化器在考虑访问计划时的选择。
Using views in a SELECT statement can restrict the join order of the tables and limit the query optimizer's choices when considering access plans.
在过去,查询XML数据的能力受到很大的限制。
The ability to query XML data has traditionally been quite limited.
虽然前面的例子中没有显示,但您可能定义了“筛选参数”(类似于示例SQL查询谓词)来限制为此图返回的行。
Although not shown in the previous example, you could have defined "filter arguments" (similar to simple SQL query predicates) to restrict the rows returned for this graph.
一个例外是在v8中,由于mqt路由限制,任何查询谓词引用的事实表列都必须包括在统计视图中。
An exception to this is in V8 where fact table columns referenced in any query predicate must be included in the statistical view definition due to MQT routing limitations.
这将提供给用户不从立方体利用SAP BW的能力,如计算并限制关键数字、查询结构、筛选器和变量。
This provides users the ability to leverage SAP BW objects not otherwise available from the cube, such as calculated and restricted key figures, query structures, filters, and variables.
这将提供给用户不从立方体利用SAP BW的能力,如计算并限制关键数字、查询结构、筛选器和变量。
This will provide users the ability to leverage SAP BW objects not otherwise available from the cube, such as calculated and restricted key figures, query structures, filters, and variables.
与变量和筛选器一起使用SAPBW查询以便限制来自BW的数据集,这有助于限制从SAP BW传递的数据的大小。
Use SAP BW queries with variables and filters to restrict the data set from BW to help limit the size of data passed from SAP BW.
可以设置一个或多个查询条件以限制查询的结果。
You can set one or more query criteria to limit the results of the query.
当然也可以编写更具选择性的SQL查询,使之包含关系投影和限制操作。
Of course, you can write more selective SQL queries that incorporate relational projection and restriction operations.
使用此参数可以限制由所附的人员查询返回的用户总数。
This parameter enables you to limit the total number of users that are returned by the enclosing staff query.
范围查询和范围过滤器是限制空间的关键机制。
Range queries and range filters are among the essential mechanisms for restricting the space.
注意,限制GET查询不能帮您解决错误的客户机数据的问题(如先前段落所讨论的)——服务器还是需要检查来自它们的客户机的数据!
(Ok, Cancel) "Note that limiting GET queries won't help you with the problem of incorrect client data (as discussed in the previous paragraph) — servers still need to check data from their clients!"
可以用来限制对用户表的查询。
Can be used to restrict queries made against the user table.
可以用来限制对组表的查询。
Can be used to restrict queries made against the group table.
下面对于每个查询的限制没有被打破
例如,以下查询将搜索限制到图5的文档模型中名称“description”所标识的文档部分,从而返回一个结果。
For example, the following query returns a result by limiting search to the document part identified by name "description" in the document model of Figure 5.
由于该查询没有包含用来限制books或authors表的值谓词,因此DB 2必须在两个表上执行表扫描,以便读取所有authorID。
Since this query contains no value predicate to restrict either the books or the authors table, DB2 has to perform a table scan on either of the two tables to read all author IDs.
正如您稍后将看到的,例外情况是Google数据API支持设置开始日期范围以限制查询结果中包括的事件。
As you'll see later, the exception is that the Google data API does support setting ranges of start dates to limit which events are included in query results.
限制产生的输出:可以使用SQLEditor提供的以下选项限制执行查询产生的输出。
Limiting the resultant output: the resultant output of the query being executing can be limited using the following options provided in the SQL Editor.
由于查询时间的限制没有执行。
这将把Google或是Yahoo的搜索查询范围限制在你的网站内部。
This will limit the scope of the Google or Yahoo search query to just your website. You may also want to modify the value of the “Submit” text to say whatever you want.
应用推荐