如果包含该列的表尚未添加,则查询设计器将该表添加到查询中。
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.
论述了在程序设计过程中,使用数据库开发工具独有的字段通用属性、查询设计器、类设计及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.
当在“条件”窗格中以特定于本地的格式输入数据时,查询和视图设计器在“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.
这些算法和相应的查询优化处理器已用于作者自行设计的并行数据库管理系统原型。
A complete set of a algorithms and techniques are proposed. the algorithms and techniques have been used in a prototype parallel database system designed by the author.
让查询和视图设计器创建自联接的步骤。
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.
按照查询预处理的处理过程,分别描述了MDBI查询预处理器中词法分析、语法分析、语义分析的设计和实现。
According to the processing procedure of query pre-compiler, this paper givens the general design and implementation of syntax analysis, semantics analysis in MDBI query pre-compiler.
在服务器层设计一个查询优化器,并研究了查询重写和代价估计优化方法以及缓存机制。
In the integration server layer, design a query optimizer and research query rewrite, cost estimation model and caches mechanism.
提出一种无线传感器网络嵌入式网关的设计方案和无线传感器网络数据管理与查询模式。
An embedded gateway of wireless sensor network was designed, and a management and query mode was proposed.
查询和视图设计器不检查该名称是否已被使用,也不检查您是否有创建表的权限。
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.
详细叙述了系统实现闭环控制、模糊控制器的结构、模糊控制规则的设计及模糊控制查询表的计算。
The implementation of closed loop control, the configuration of the fuzzy controller, the design of fuzzy control regulation and the calculation of fuzzy control inquiring table are described.
详细叙述了系统实现闭环控制、模糊控制器的结构、模糊控制规则的设计及模糊控制查询表的计算。
The implementation of closed loop control, the configuration of the fuzzy controller, the design of fuzzy control regulation and the calculation of fuzzy control inquiring table are described.
应用推荐