通过

NotificationClass.NotificationComputedFields Property

  • 项目

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.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

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

其他资源

ComputedFields Element (ADF)
定义通知架构
定义通知类