共用方式為


MergeSubsetFilter Object

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The MergeSubsetFilter object represents a filter (or partition) of the data in one article based on filtered data in another article. Both articles must be part of the same merge publication.

顯示目前物件的 SQL-DMO 物件模型

Methods

BeginAlter Method

DoAlter Method

CancelAlter Method

Remove Method (Objects)

Properties

ID Property

JoinUniqueKey Property

JoinArticleName Property

Name Property

JoinFilterClause Property

 

備註

A MergeSubsetFilter object is commonly used when two tables have a primary-key-to-foreign-key relationship. If the MergeArticle object representing the primary key table has a SubsetFilterClause object defined, add a MergeSubsetFilter object (that references the primary key article) to the MergeArticle object representing the foreign key table.

With the MergeSubsetFilter object, you can:

  • Add a merge filter.
  • Change the properties of an existing merge filter.

To add a merge filter to a merge article

  1. Create a new MergeSubsetFilter object.

  2. Set the Name property.

  3. Set the JoinArticleName property.

  4. Set the JoinFilterClause property.

  5. Add the MergeSubsetFilter object to the MergeSubsetFilters collection of a connected MergeArticle object.

To alter an existing merge filter of a merge article

  1. Get a MergeSubsetFilter object from the MergeSubsetFilters collection of a connected MergeArticle object.

  2. Use the BeginAlter method to mark the beginning of the changes.

  3. Set the MergeSubsetFilter properties to reflect the changes to the merge filter.

  4. Use the DoAlter method to submit the changes to Microsoft SQL Server.