Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

<SqlExpression> Element (/Protocol/Fields/Field)

SQL Server 2000

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

Structure
<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 /NotificationClasses/NotificationClass/Protocols/Protocol/Fields/Field node.
Updates Can be modified, but not added or deleted, using NSControl Update.
Element Relationships
Relationship Elements
Parent Node <Field> Node (/Protocol/Fields)
Remarks

If you update a <SqlExpression> element, NSControl Update 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.

Important  If you update a <SqlExpression> element, any data existing in the original SQL Server tables is permanently deleted.

Important  If a <SqlExpression> element is not included in the <Field> node, a <FieldReference> element must be provided instead.

See Also
Documenting the Delivery Protocols
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.