Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Specifies a valid Transact-SQL expression that provides the protocol field value.
Syntax
<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. |
Remarks
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 Expressions (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.
Example
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>
See Also
Reference
Application Definition File Reference
Other Resources
Specifying the Delivery Protocol Name and Fields
Expressions (Database Engine)
Updating Instances and Applications