NotificationClass.NotificationComputedFields Property

Статья
12/15/2008

Gets the collection of computed fields for the notification class.

Пространство имен: Microsoft.SqlServer.Management.Nmo
Сборка: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Синтаксис

'Декларация
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

Значение свойства

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

Замечания

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

Пример

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)

Синхронизация потоков

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.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

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

Другие ресурсы

ComputedFields Element (ADF)
Определение схемы уведомления
Определение классов уведомлений

Поделиться через