您要查找的是不是：
- Changes a key column of the partitioned view or table. 更改分区视图或表的键列。
- Any linked server in the partitioned view cannot be a loopback linked server. 分区视图中的所有链接服务器都不能是环回链接服务器。
- This appears to the user as a single table that is called a partitioned view. 这在用户看来是一个单独的表,称为分区视图。
- Query contains updatable partitioned views. 查询包含可更新的分区视图。
- A view that joins member tables on the same instance of SQL Server is a local partitioned view. 联接同一个SQL Server实例中的成员表的视图是一个本地分区视图。
- A distributed partitioned view cannot be formed by using the EXCEPT or INTERSECT operators. 不能使用EXCEPT或INTERSECT运算符来形成分布式分区视图。
- The xml data type cannot be used in Distributed Partitioned Views. 不能将xml数据类型用于分布式分区视图。
- A specified table that participates in the partitioned view may not be actually used in a specific execution of a query against the view. 在对分区视图执行某次特定查询时,可能实际上并未使用组成该视图的某个指定表。
- EXCEPT and INTERSECT cannot be used in distributed partitioned view definitions, query notifications, or together with COMPUTE and COMPUTE BY clauses. EXCEPT和INTERSECT不能在分布式分区视图定义、查询通知中使用,也不能与COMPUTE和COMPUTE BY子句一起使用。
- After you create the member tables, you define a distributed partitioned view on each member server, with each view having the same name. 创建成员表之后,在每个成员服务器上定义一个分布式分区视图,并且各个视图具有相同的名称。
- Also, CHECK constraints are put in place to differentiate the member tables, and this prevents data duplication across the partitioned view. 此外,还会在适当位置放置CHECK约束来区分这些成员表,而这会阻止跨已分区视图复制数据。
- Cannot update partitioning column '%.*ls' on partitioned view '%.*ls'. 无法更新分区视图 ''%253!'' 上的分区列 ''%251!''。
- A view is considered an updatable partitioned view when the view is a set of SELECT statements whose individual result sets are combined into one using the UNION ALL statement. 当视图是一组SELECT语句,这些语句各自的结果集使用UNION ALL语句合并在一起时,该视图被视为可更新的分区视图。
- The system operates as if a copy of the original table is on each member server, but each server has only a member table and a distributed partitioned view. 系统将像每个成员服务器上都有原表的一个副本那样进行操作,但其实每个服务器上只有一个成员表和一个分布式分区视图。
- Code the general business services tier components or applications to always call the data routing component when executing an SQL statement referencing the partitioned view. 对常规业务服务层组件或应用程序进行编码,使其在执行引用分区视图的SQL语句时始终调用数据路由组件。
- It may also choose suboptimal plans for queries posed on partitioned tables and distributed partitioned views. 它还可能会选择对分区表和分布式分区视图执行的不太理想的查询计划。
- TOP cannot be used together with UPDATE and DELETE statements on partitioned views. 在已分区视图中,不能将TOP与UPDATE和DELETE语句一起使用。
- The following conditions do not apply to locally partitioned views created on the same server. 下列条件不适用于在同一计算机上创建的本地分区视图。
- The setting of the SET ROWCOUNT option is ignored for INSERT, UPDATE, and DELETE actions that involve updatable partitioned views and remote tables. 对于涉及可更新分区视图和远程表的INSERT、UPDATE和DELETE操作,忽略SET ROWCOUNT选项的设置。
- To meet the conditions of the partitioned view, there should be only one partitioning constraint on the partitioning column. 若要满足分区视图的条件,在分区列上应只有一个分区约束。
