SqlExpression Element for Protocol/Fields/Field (ADF)

Specifies a valid Transact-SQL expression that provides the protocol field value.

語法

<NotificationClasses>
    <NotificationClass>
        ...
        <Protocols>
            <Protocol>
                ...
                <Fields>
                    <Field>
                        ...
                        <SqlExpression>

Element Characteristics

Characteristic	Description
Data type	string, between 0 and 4,000 characters in length.
Default value	None.
Occurrence	Optional 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 Protocol/Fields (ADF)
Child elements	None.

備註

A Transact-SQL expression is a combination of identifiers, values, and operators that the database engine can evaluate to get a result. You can use any expression that can be part of a SELECT statement. The terms of the expression can be any of the following:

• Constants.
• Calls to functions.
• The notification fields defined in the ADF (but not computed fields).
• The following built-in notification fields:
  • SubscriberId
  • DeviceName
  • DeviceTypeName
  • DeviceAddress
  • SubscriberLocale
  • DeliveryChannelName

For more information, see 運算式 (Database Engine).

Enclose string constants in single quotation marks.

If a Field element does not include a SqlExpression element, it must include a FieldReference element.

範例

The following example shows a how to define a Transact-SQL expression that concatenates a string with a notification field. This could be used as a subject line for an e-mail message.

<SqlExpression>
    'Stock Price Update for ' + StockSymbol
</SqlExpression>

請參閱

參考

Application Definition File Reference

其他資源

指定傳遞通訊協定名稱與欄位
運算式 (Database Engine)
更新執行個體及應用程式

說明及資訊

取得 SQL Server 2005 協助