<SqlExpression> Element (<ComputedField>)
Collapse the table of content
Expand the table of content

<SqlExpression> Element (<ComputedField>)

SQL Server 2000

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


Element Characteristics
Characteristic Description
Data Type string, between 0 and 4,000 characters in length.
Default Value None.
Occurrence Required once per <ComputedField> node.
Updates Can be modified, but not added or deleted, using NSControl Update.
Element Relationships
Relationship Elements
Parent Node <ComputedField> Node

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.

See Also
Defining the Notification Fields
© 2016 Microsoft