JoinClause Constructor (Column, Column)

Initializes a new instance of the JoinClause class with source and target columns.

Espace de noms: Microsoft.SqlServer.NotificationServices.Rules
Assembly: Microsoft.SqlServer.NotificationServices.Rules (in microsoft.sqlserver.notificationservices.rules.dll)

Syntaxe

'Déclaration
Public Sub New ( _
    sourceColumn As Column, _
    targetColumn As Column _
)

public JoinClause (
    Column sourceColumn,
    Column targetColumn
)

public:
JoinClause (
    Column^ sourceColumn, 
    Column^ targetColumn
)

public JoinClause (
    Column sourceColumn, 
    Column targetColumn
)

public function JoinClause (
    sourceColumn : Column, 
    targetColumn : Column
)

Paramètres

• sourceColumn
  A Column object that represents the source column in the join. This parameter sets the SourceColumn property.

• targetColumn
  A Column object that represents the target column in the join. This parameter sets the TargetColumn property.

Exemple

The following example shows how to use JoinClause objects to define a chain of joins between an event view and a table:

// Subscribe to products in Subassembly location. This
// requires select permissions on all tables in the sample.

//Specify server and database.
Server server = new Server("MyServer");
Database db = server.Databases[nsApplication.DatabaseName];

// Specify tables and views used by the condition.
Table locationTable = db.Tables["Location", "Production"];
Table inventoryTable = db.Tables["ProductInventory", "Production"];
View eventView = db.Views["InventoryTrackerEvents",
    "NS_InventoryTrackerApplication"];

// Filter defining "Subassembly" locations.
FilterRule toolCrib = new FilterRule(
    new TableInputType(db.Tables["Location", "Production"]),
    new SimpleLeafCondition(new FieldValue("Name"),
        SimpleOperator.Equals, "Subassembly"));

// Create subscription and define basic properties.
s = new Subscription(nsApplication, subscriptionClassName);
s.SubscriberId = "Stephanie";
s.Enabled = true;
s.RuleName = "InventoryTrackerRule";
s.SetFieldValue("DeviceName", "myDevice");
s.SetFieldValue("SubscriberLocale", "en-us");

// Define a condition using the filter.
s.Condition = new LinkLeafCondition(
    LinkLeafOperator.Any,
    toolCrib,
    new JoinClause(eventView.Columns["ProductId"],
        inventoryTable.Columns["ProductId"]),
    new JoinClause(inventoryTable.Columns["LocationId"],
        locationTable.Columns["LocationId"]));

// Add subscription.
s.Add();

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

JoinClause Class
JoinClause Members
Microsoft.SqlServer.NotificationServices.Rules Namespace