UNION查询现在由查询设计器进行格式设置。
如果包含该列的表尚未添加，则查询设计器将该表添加到查询中。
If the table containing that column has not already been added, the query Designer adds it to the query.
因此，当使用UNION查询时，查询设计器将隐藏“表操作”窗格。
Therefore, when you are working with a UNION query, query Designer hides the Table Operations pane.
因此，尽管您可能无法更新所有的视图，但查询设计器仍会把它们全部显示出来。
Therefore, it displays all views, even though you might not be able to update them.
论述了在程序设计过程中，使用数据库开发工具独有的字段通用属性、查询设计器、类设计及SQL语言等功能，完成信息管理系统的设计过程。
This paper has a discussion on the process of information management design to use the common property of Database tools, query designer, class design, SQL language in the process of program design.
类型化数据集设计器允许你添加自己的查询语句，通过在适当表格的上下文菜单中选择“添加”|“查询”来实现。
The typed DataSet designer accommodates by allowing you to add your own queries from the appropriate table's context menu by selecting add | Query from the table's context menu.
设计器同时也产生一个填充查询，它封装了查询相关表的Select语句并且在类型化数据集中以同名方法实现。
The designer also generates a Fill query, which wraps the table's SELECT statement and is implemented as a method of the same name on the typed DataSet.
如果sql语句设计得很糟，优化器就很难转换查询，在选择最佳访问路径时的选择就很少。
If the SQL statement is badly coded, it is difficult for the optimizer to transform the query, leaving fewer options available for choosing an optimal access path.
针对管理信息系统的要求，遵循通用的设计思想，开发了管理信息系统通用查询器。
To meet the demand of managing information system and follow the general designing thoughts, a general searcher of MIS is developed.
并针对传统查询优化器对于大规模海量数据统计信息更新不及时的问题，设计了一种基于分区技术的统计方法。
Focus on problem of statistics of query optimizer on update, we design a statistics method based on partition technique.
以数据记录指针的定位及查询功能的实现为例，详细介绍了使用类设计器将系统控件组合成用户定义控件的方法。
Introduce a way to merge several system controls into a custom control with class designer by the example of implementing record Pointers locating and query function.
查询解析错误-请试着在“查询向导”中或通过用“视图设计器”的“联接”选项卡重建。
Query Parse Error - try rebuilding in Query Wizard or by using View Designer Join Tab.
如果您对表或表值对象没有足够的访问权限，或者提供程序无法返回有关它的信息，那么查询和视图设计器将不显示该表或表值对象的数据列。
The Query and View Designer will not display data columns for a table or table-valued object if you do not have sufficient access rights to it or if the provider cannot return information about it.
如果可以创建多个联接，查询和视图设计器在根据所找到的第一组匹配列创建一个联接后即会停止。
If more than one join is possible, the Query and View Designer stops after creating a join based on the first set of matching columns that it finds.
如果您处理多个表，则查询和视图设计器将检查每个搜索条件以确定正在进行的比较是否将导致联接。
If you are working with multiple tables, the Query and View Designer examines each search condition to determine whether the comparison you are making results in a join.
让查询和视图设计器决定是否应联接表的步骤。
Steps for allowing the Query and View Designer determine if tables should be joined.
一般情况下，为了更新结果，查询和视图设计器必需具备足够的信息才能唯一地标识表中的行。
In general, in order to update results, the Query and View Designer must have sufficient information to uniquely identify the row in the table.
当向“条件”窗格添加要搜索的列时，查询和视图设计器也会将该列添加到要复制的列的列表中。
When you add a column to search to the Criteria pane, the Query and View Designer also adds it to the list of columns to copy.
如果将导致联接，查询和视图设计器会自动将搜索条件转换为联接。
If so, the Query and View Designer automatically converts the search condition into a join.
当在“条件”窗格中以特定于本地的格式输入数据时，查询和视图设计器在“SQL”窗格中会自动将其转换为ANSI 格式。
When you enter data using local-specific format in the Criteria pane, the Query and View Designer automatically translates it to ANSI format in the SQL pane.
如果相关，查询和视图设计器自动在表示表或表结构对象的矩形之间添加联接线。
If they are, the Query and View Designer automatically puts join lines between the rectangles representing the tables or table-structured objects.
本文论述了在IIS服务器上，使用ASP设计一种网站数据库的查询方法。
This paper discussed the inquiry method of active web site database using ASP design on IIS server.
让查询和视图设计器创建自联接的步骤。
Steps for allowing the Query and View Designer to create a self-join.
描述查询和视图设计器的功能。
Describes the features and capabilities of the Query and View Designer.
了解组合AND和OR子句时它们的相关方式将有助于构造和理解查询和视图设计器中的复杂查询。
Understanding how and and OR clauses are related when combined can help you construct and understand complex queries in the Query and View Designer.
在服务器层设计一个查询优化器，并研究了查询重写和代价估计优化方法以及缓存机制。
In the integration server layer, design a query optimizer and research query rewrite, cost estimation model and caches mechanism.
查询和视图设计器不检查该名称是否已被使用，也不检查您是否有创建表的权限。
The Query and View Designer does not check whether the name is already in use or whether you have permission to create the table.
查询和视图设计器根据具有相同名称和数据类型的列仅创建一个联接。
The Query and View Designer will create only one join based on columns with the same name and data type.
提供可在查询和视图设计器中使用的组合键和鼠标操作的列表。
Provides a list of key combinations and mouse operations you can use in the Qeury and View Designer.
提供可在查询和视图设计器中使用的组合键和鼠标操作的列表。
Provides a list of key combinations and mouse operations you can use in the Qeury and View Designer.
应用推荐