共用方式為


FieldName Element for NotificationClass/Schema/Fields/Field (ADF)

Specifies the user-defined name of the notification field.

語法

<NotificationClasses>
    <NotificationClass>
        ...
        <Schema>
            <Fields>
                <Field>
                    <FieldName>

Element Characteristics

Characteristic Description

Data type

string, between 1 and 128 characters in length.

Default value

None.

Occurrence

Required once per Field element.

Updates

Can be modified, but not added or deleted, when updating the application.

Element Relationships

Relationship Elements

Parent element

Field Element for Schema/Fields (ADF)

Child elements

None.

備註

Field names can contain letters, numbers, and the special characters _, #, @, and $. They must also conform to Microsoft SQL Server identifier conventions. For more information about SQL Server identifiers, see 識別碼.

SQL Server 2005 Notification Services reserves the following field names. Do not create notification fields with these names:

  • DeliveryChannelName
  • DeliveryStatusCode
  • DeviceAddress
  • DeviceName
  • DeviceTypeName
  • DistributorWorkItemId
  • ExpirationTime
  • LinkNotificationId
  • NotificationId
  • NotificationBatchId
  • SentTime
  • SubscriberId
  • SubscriberLocale
ms146568.note(zh-tw,SQL.90).gif重要事項:
If you update a FieldName element, updating the application deletes and re-creates the notification class to which it corresponds. This includes dropping and re-creating the SQL Server tables used by this notification class. Any data existing in the original notification class tables is permanently deleted.

範例

The following example shows a FieldName element.

<FieldName>StockPrice</FieldName>

請參閱

參考

Application Definition File Reference

其他資源

定義通知結構描述
更新執行個體及應用程式

說明及資訊

取得 SQL Server 2005 協助