<SqlExpression> Element (/Protocol/Fields/Field)
Collapse the table of content
Expand the table of content

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

SQL Server 2000

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


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)

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
© 2016 Microsoft