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 지원 받기