共用方式為


Schema Element for NotificationClass (ADF)

Contains elements that define notification class fields.

語法

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

Element Characteristics

Characteristic Description

Data type

None.

Default value

None.

Occurrence

Required once per NotificationClass element.

Updates

Cannot be added or deleted when updating the application.

Element Relationships

Relationship Elements

Parent element

NotificationClass Element (ADF)

Child elements

Fields Element for Schema (ADF)

ComputedFields Element (ADF)

備註

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 協助