Schema Element for NotificationClass (ADF)

Contains elements that define notification class fields.

Синтаксис

<NotificationClasses>
    <NotificationClass>
        ...
        <Schema>

Element Characteristics

Element Relationships

Замечания

A notification class schema defines the schema of the notification data in the application database. SQL Server 2005 Notification Services uses the fields defined in the schema to construct a table to store the notification data. Notification Services adds columns to the table for identifying and tracking notifications and to identify the subscriber, device, and locale.

Пример

The following example shows a Schema element that defines three notification fields: a 10-character stock symbol field, and a stock value field that accepts monetary data, and a computed field that determines how much the stock price has changed.

<Schema>
    <Fields>
        <Field>
            <FieldName>StockSymbol</FieldName>
            <FieldType>char(10)</FieldType>
            <DigestGrouping>true<DigestGrouping>
        </Field>
        <Field>
            <FieldName>StockPrice</FieldName>
            <FieldType>money</FieldType>
        </Field>
    </Fields>
    <ComputedFields>
        <ComputedField>
            <FieldName>StockPriceChar</FieldName>
            <SqlExpression>CONVERT(NVARCHAR(10), StockPrice, 1)
            </SqlExpression>
        </ComputedField>
    </ComputedFields>
</Schema>

См. также

Справочник

Application Definition File Reference

Другие ресурсы

Определение схемы уведомления
Обновление экземпляров и приложений

Справка и поддержка

Получение помощи по SQL Server 2005