在Script窗格中选择任何映射语句,这将显示该语句中所引用的所有源和目标可映射对象,如映射源、循环迭代器、条件、where子句,等等。
Selecting any mapping statement in the Script Pane shows all source and target mappables referenced in the statement, such as mapping source, loop iterator, condition, where clause, and so on.
查询和视图设计器表示“条件”窗格中的搜索条件。
The Query and View Designer represents your search conditions in the Criteria Pane.
但是,在某些情况下涉及到与AND和OR链接的多个子句,“条件”窗格中的表示形式与预期的可能不一样。
However, in some cases that involve multiple clauses linked with and and OR, the representation in the Criteria Pane might not be what you expect.
不应在“条件”窗格中输入货币符号。
Currency symbols should not be entered in the Criteria pane.
这些列将显示在“条件”窗格中。
视图设计器包含四个窗格:“关系图”窗格、“条件”窗格、“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.
当您创建“删除”查询时,“条件”窗格发生变化以反映可用于删除行的选项。
When you create a Delete query, the Criteria pane changes to reflect the options available for deleting rows.
重新创建的sql语句将与“条件”窗格的显示相似,而不是与原始语句相似。
The recreated SQL statement will resemble the Criteria Pane display rather than your original statement.
如果不想使某特定列成为GROUPBY子句的一部分,必须在“条件”窗格的“分组依据”列中选择不同的选项以手动更改该设置。
If you do not want a particular column to be part of the Group by clause, you must manually change it by selecting a different option in the Group by column of the Criteria pane.
如果在“条件”窗格或“SQL”窗格中手动向聚合函数添加查询输出列,则查询和视图设计器不能自动从查询中移除其他输出列。
If you manually add a query output column to an aggregate function in either the Criteria or SQL pane, the query and View Designer does not automatically remove other output columns from the query.
例如,如果“条件”窗格中包含分布式的and子句,将用显式分布式的and子句重新创建“SQL”窗格中的结果语句。
For example, if the Criteria pane contains distributed AND clauses, the resulting statement in the SQL pane will be recreated with explicit distributed AND clauses.
另外,如果在“条件”窗格或“关系图”窗格中修改查询,可能会发现更改所得到的sql语句与所输入的语句不同。
In addition, if you modify your query in the Criteria pane or Diagram pane, you might find that your SQL statement has been changed from what you entered.
当在“条件”窗格中以特定于本地的格式输入数据时,查询和视图设计器在“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.
在查询和视图设计器中,请确保“条件”窗格可见。
In the Query and View Designer, be sure the Criteria pane is visible.
当移动到另一窗格时,查询和视图设计器会自动将语句格式化,然后更改“关系图”窗格和“条件”窗格以与该语句匹配。
When you move to another pane, the Query and View Designer automatically formats your statement, and then changes the Diagram and Criteria panes to match your statement.
例如,如果“区域设置”设置为“标准德语”,则可以在“条件”窗格中以类似“31.12.96”的格式输入数据。
For example, if your Regional Settings are set to Standard German, you can enter data in the Criteria pane in a format such as "31.12.96."
例如,如果“区域设置”设置为“标准德语”,则可以在“条件”窗格中以类似“31.12.96”的格式输入数据。
For example, if your Regional Settings are set to Standard German, you can enter data in the Criteria pane in a format such as "31.12.96."
应用推荐