For distributed partitioned views when one or more member tables are remote , the following additional conditions apply 对于分布式分区视图(其中有一个或多个成员表为远程表) ,适用下列附加条件:
The setting of the set rowcount option is ignored for delete statements against remote tables and local and remote partitioned views 对远程表和本地及远程分区视图上的delete语句将忽略set rowcount选项的设置。
The setting of the set rowcount option is ignored for update statements against remote tables and local and remote partitioned views 对于用于远程表以及本地和远程分区视图的update语句,忽略set rowcount选项的设置。
Is not supported in dml statements that reference local partitioned views , distributed partitioned views , or remote tables , or insert statements that contain an 引用本地分区视图、分布式分区视图或远程表的dml语句,或包含
If the remote tables have restrictions on the data such as check constraints , you can convey these restrictions to the federated server using 如果远程表在数据上有检查约束,那么可以使用信息检查约束将这些约束传递到联邦服务器。
A better solution is to define a nickname over each remote table , and to define views over these nicknames on the federated server if necessary 更好的解决办法是定义每个远程表的昵称,必要的时候在联邦服务器上定义这些昵称上的视图。
Given the remote table definitions for items and suppliers , you can declare check constraints on the corresponding nicknames with the following commands 给items和suppliers的定远程表定义,便可以用以下语句声明相应昵称上的检查约束:
Automatic meter reading system ( amrs ) is a modern administration system which collects and reads remote consumption data through modern communication network 远程抄表系统是利用现代通讯网络实现远程表计数据管理的一种新兴管理系统。
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选项的设置。
This means that the caller of a distributed query must have control , alter , take ownership , or view definition permission on the remote table 这意味着分布式查询的调用方必须对远程表具有control 、 alter 、 take ownership或view definition权限。