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

<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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.