Export (0) Print
Expand All
Expand Minimize

<SqlExpression> Element (<ComputedField>)

SQL Server 2000

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

Structure
<NotificationClasses>
   <NotificationClass>
      ...
      <Schema>
         ...
         <ComputedFields>
            <ComputedField>
               ...
               <SqlExpression>

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
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.

See Also
Defining the Notification Fields
Show:
© 2014 Microsoft