共用方式為

NotificationComputedField Constructor (NotificationClass, String)

Initializes a new instance of the NotificationComputedField class with the parent NotificationClass and a name.

命名空間: Microsoft.SqlServer.Management.Nmo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

語法

'宣告
Public Sub New ( _
    notificationClass As NotificationClass, _
    name As String _
)

public NotificationComputedField (
    NotificationClass notificationClass,
    string name
)

public:
NotificationComputedField (
    NotificationClass^ notificationClass, 
    String^ name
)

public NotificationComputedField (
    NotificationClass notificationClass, 
    String name
)

public function NotificationComputedField (
    notificationClass : NotificationClass, 
    name : String
)

參數

  • name
    A String, between 1 and 128 characters in length, that specifies the name of the computed field.

    You cannot change the name. To rename a computed field, you must remove the field and then add a new field that has the new name.

備註

Field names can contain letters, numbers, and the special characters _#@ and $. They must also conform to Microsoft SQL Server identifier conventions. For more information about SQL Server identifiers, see 識別碼.

If you change a field name, updating the application 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. Any data existing in the original notification class tables is permanently deleted.

This constructor sets the DigestGrouping property to false.

範例

The following example shows how to define a computed field 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)

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

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

其他資源

FieldName Element for NotificationClass/Schema/ComputedFields/ComputedField (ADF)
定義通知結構描述
ComputedField Element (ADF)

  • Last updated on