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 |
|
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 식(데이터베이스 엔진).
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
관련 자료
배달 프로토콜 이름 및 필드 지정
식(데이터베이스 엔진)
인스턴스 및 응용 프로그램 업데이트