NotificationClass.NotificationComputedFields Property

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

Eigenschaftswert

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

Hinweise

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

Beispiel

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)

Threadsicherheit

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.

Plattformen

Entwicklungsplattformen

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Zielplattforme

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Siehe auch

Verweis

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

Andere Ressourcen

ComputedFields Element (ADF)
Definieren des Benachrichtigungsschemas
Definieren von Benachrichtigungsklassen