描述查询和视图设计器的功能。
Describes the features and capabilities of the Query and View Designer.
让查询和视图设计器创建自联接的步骤。
Steps for allowing the Query and View Designer to create a self-join.
让查询和视图设计器决定是否应联接表的步骤。
Steps for allowing the Query and View Designer determine if tables should be joined.
可使用键盘或鼠标在查询和视图设计器中工作。
You can work in the Query and View Designer using the keyboard or the mouse.
查询和视图设计器表示“条件”窗格中的搜索条件。
The Query and View Designer represents your search conditions in the Criteria Pane.
查询和视图设计器为表的第二个实例分配一个别名。
The Query and View Designer assigns an alias to the second instance of the table.
在查询和视图设计器中,请确保“条件”窗格可见。
In the Query and View Designer, be sure the Criteria pane is visible.
“查询及视图设计器”将自动为要汇总的列分配列别名。
The Query and View Designer automatically assigns a column alias to the column you are summarizing.
如果查询和视图设计器无法选择匹配列,则必须提供列名。
If the Query and View Designer cannot choose a match, you must provide the column name.
打开一个视图或创建一个新查询以打开查询和视图设计器。
Open a view or create a new query to open the query and view Designer.
可以在查询和视图设计器的“属性”窗口中显示查询的属性。
You can display properties for a query in the properties window from query and View Designer.
提供可在查询和视图设计器中使用的组合键和鼠标操作的列表。
Provides a list of key combinations and mouse operations you can use in the Qeury and View Designer.
查询和视图设计器工具进行某些假设以便可以构造有效的查询。
Query and View Designer Tools makes certain assumptions so that it can construct a valid query.
查询和视图设计器无法事先确定您是否可更新基于视图的结果集。
The Query and View Designer cannot determine in advance whether you can update a result set based on a view.
如果将导致联接,查询和视图设计器会自动将搜索条件转换为联接。
If so, the Query and View Designer automatically converts the search condition into a join.
查询和视图设计器根据具有相同名称和数据类型的列仅创建一个联接。
The Query and View Designer will create only one join based on columns with the same name and data type.
然而,查询和视图设计器不会防止您选择可能产生无法运行的查询的选项。
However, the query and View Designer will not prevent you from choosing an option that can result in a query that will not run.
视图设计器是VisualStudio 2005的IBM工具中存在的新特性。
The view designer is a new feature available in the IBM tooling for Visual Studio 2005.
视图设计器的用户界面启用或禁用某些特性,允许或防止对视图执行某些更改。
The user interface for the view designer enables or disables certain features, thus allowing or preventing you from performing certain alterations to the view.
当您在查询和视图设计器中打开查询时,这些属性将出现在“属性”窗口中。
These properties appear in the properties window when you have a query open in query and View Designer.
查询和视图设计器不检查该名称是否已被使用,也不检查您是否有创建表的权限。
The Query and View Designer does not check whether the name is already in use or whether you have permission to create the table.
如果相关,查询和视图设计器自动在表示表或表结构对象的矩形之间添加联接线。
If they are, the Query and View Designer automatically puts join lines between the rectangles representing the tables or table-structured objects.
查询和视图设计器将自动为表达式分配列别名,以在查询输出中创建有用的列标题。
The query and View Designer automatically assigns a column alias to the expression to create a useful column heading in query output.
查询解析错误-请试着在“查询向导”中或通过用“视图设计器”的“联接”选项卡重建。
Query Parse Error - try rebuilding in Query Wizard or by using View Designer Join Tab.
用来输入日期的格式取决于所使用的数据库和在查询和视图设计器的哪个窗格中输入日期。
The format you use to enter dates depends on the database you are using and in what pane of the Query and View Designer you are entering the date.
一般情况下,为了更新结果,查询和视图设计器必需具备足够的信息才能唯一地标识表中的行。
In general, in order to update results, the Query and View Designer must have sufficient information to uniquely identify the row in the table.
视图设计器包含四个窗格:“关系图”窗格、“条件”窗格、“SQL”窗格和“结果”窗格。
View Designer has four panes: the Diagram pane, the Criteria pane, the SQL pane, and the Results pane.
当向“条件”窗格添加要搜索的列时,查询和视图设计器也会将该列添加到要复制的列的列表中。
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.
当您打开视图的定义,显示查询或视图的结果或者创建或打开查询时,查询和视图设计器将打开。
The query and view Designer opens when you open the definition of a view, show the results for a query or view, or create or open a query.
如果可以创建多个联接,查询和视图设计器在根据所找到的第一组匹配列创建一个联接后即会停止。
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.
应用推荐