Partilhar via

NotificationClass.NotificationComputedFields Property

  • Artigo

Gets the collection of computed fields for the notification class.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public ReadOnly Property NotificationComputedFields As NotificationComputedFieldCollection

public NotificationComputedFieldCollection NotificationComputedFields { get; }

public:
property NotificationComputedFieldCollection^ NotificationComputedFields {
    NotificationComputedFieldCollection^ get ();
}

/** @property */
public NotificationComputedFieldCollection get_NotificationComputedFields ()

public function get NotificationComputedFields () : NotificationComputedFieldCollection

Property Value

A NotificationComputedFieldCollection object that represents the collection of computed fields for the notification class.

Remarks

Computed fields, which are optional, use Transact-SQL expressions to compute notification data immediately before the content is passed to the content formatter.

Example

The following examples show how to define a computed field and then add it to the collection of computed fields for a notification class:

NotificationComputedField computedPrice = 
    new NotificationComputedField(flightNotifications, 
    "FormattedPrice");
computedPrice.SqlExpression = "CONVERT(NVARCHAR(10), Price, 1)";
flightNotifications.NotificationComputedFields.Add(computedPrice);

Dim computedPrice As NotificationComputedField = _
    New NotificationComputedField(flightNotifications, _
    "FormattedPrice")
computedPrice.SqlExpression = "CONVERT(NVARCHAR(10), Price, 1)"
flightNotifications.NotificationComputedFields.Add( _
    computedPrice)

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

NotificationClass Class
NotificationClass Members
Microsoft.SqlServer.Management.Nmo Namespace

Other Resources

ComputedFields Element (ADF)
Defining the Notification Schema
Defining Notification Classes