SubscriptionScheduledRule Constructor ()

Articolo
12/15/2008

Initializes a new instance of the SubscriptionScheduledRule class.

Spazio dei nomi: Microsoft.SqlServer.Management.Nmo
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Sintassi

'Dichiarazione
Public Sub New

public SubscriptionScheduledRule ()

public:
SubscriptionScheduledRule ()

public SubscriptionScheduledRule ()

public function SubscriptionScheduledRule ()

Osservazioni

Testo aggiornato:5 dicembre 2005

Codice di esempio aggiornato:5 dicembre 2005

When using the default constructor, first set the Name, then the Parent and then other properties to avoid runtime exceptions. This constructor does not set any property values.

Esempio

The following examples show how to use this default constructor to create a scheduled rule and then add the rule to a subscription class:

// Create a scheduled rule and set properties.
SubscriptionScheduledRule flightScheduledRule = 
    new SubscriptionScheduledRule();
flightScheduledRule.Name = "FlightScheduledRule";
flightScheduledRule.Parent = flightSubscriptions;
flightScheduledRule.Action = "INSERT INTO FlightNotifications " + 
    "(SubscriberId, DeviceName, SubscriberLocale, " +
    " LeavingFrom, GoingTo, Price) " + 
    " SELECT S.SubscriberId, S.DeviceName, S.SubscriberLocale, " +
    " EC.LeavingFrom, EC.GoingTo, EC.Price " + 
    " FROM FlightEventChronicle EC, FlightSubscriptions S " +
    " WHERE EC.LeavingFrom = S.LeavingFrom " + 
    " AND EC.GoingTo = S.GoingTo " +
    " AND EC.Price < S.Price";
flightScheduledRule.ActionTimeout = new TimeSpan(0, 30, 0);
flightSubscriptions.SubscriptionScheduledRules.Add(
    flightScheduledRule);

' Create a scheduled rule and set properties.
Dim flightScheduledRule As SubscriptionScheduledRule = _
    New SubscriptionScheduledRule()
flightScheduledRule.Name = "FlightScheduledRule"
flightScheduledRule.Parent = flightSubscriptions
flightScheduledRule.Action = "INSERT INTO FlightNotifications " + _
    "(SubscriberId, DeviceName, SubscriberLocale, " + _
    " LeavingFrom, GoingTo, Price) " + _
    " SELECT S.SubscriberId, S.DeviceName, S.SubscriberLocale, " + _
    " EC.LeavingFrom, EC.GoingTo, EC.Price " + _
    " FROM FlightEventChronicle EC, FlightSubscriptions S " + _
    " WHERE EC.LeavingFrom = S.LeavingFrom " + _
    " AND EC.GoingTo = S.GoingTo " + _
    " AND EC.Price < S.Price"
flightScheduledRule.ActionTimeout = New TimeSpan(0, 30, 0)
flightSubscriptions.SubscriptionScheduledRules.Add(flightScheduledRule)

Piattaforme

Piattaforme di sviluppo

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Piattaforme di destinazione

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Vedere anche

Riferimento

SubscriptionScheduledRule Class
SubscriptionScheduledRule Members
Microsoft.SqlServer.Management.Nmo Namespace

Condividi tramite