Action Element for EventRule (ADF)

Provides a Transact-SQL statement that specifies the action to be taken in a subscription event rule.

Syntax

<SubscriptionClasses>
    <SubscriptionClass>
        ...
        <EventRules>
            <EventRule>
                ...
                <Action>

Element Characteristics

Element Relationships

Beispiel

This example shows a populated Action element for an EventRule. The Transact-SQL statements use a notification function to create notifications, and also insert event data into a chronicle table.

<Action>
-- Insert notifications into StockNotifications view
INSERT INTO StockNotifications ( SubscriberId, DeviceName,
    SubscriberLocale, StockSymbol, StockPrice )
SELECT S.SubscriberId, S.DeviceName, S.SubscriberLocale,
        E.StockSymbol, E.StockPrice
    FROM StockSubscriptions S JOIN StockEvents E
    ON S.StockSymbol = E.StockSymbol
    JOIN StockEventChron C
    ON S.StockSymbol = C.StockSymbol
    WHERE S.StockTriggerPrice &lt;= E.StockPrice
        AND S.StockTriggerPrice &gt; C.StockHighPrice;
-- Update the subscription chronicle
INSERT StockSubscriptionChron (SubscriberId, StockSymbol, StockPrice)
SELECT S.SubscriberId, S.StockSymbol, E.StockPrice
    FROM StockSubscriptions S JOIN StockEvents E
    ON S.StockSymbol = E.StockSymbol;
</Action>

Siehe auch

Verweis

Application Definition File Reference

Andere Ressourcen

Definieren von Ereignisregeln
Definieren von Abonnementregeln
Aktualisieren von Instanzen und Anwendungen

Hilfe und Informationen

Informationsquellen für SQL Server 2005