Jaa

NotificationComputedField Constructor (NotificationClass, String)

  • Artikkeli

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

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

Syntax

'Declaration
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
)

Parameters

  • 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.

Remarks

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 Identifiers.

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.

Example

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)

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

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

Other Resources

FieldName Element for NotificationClass/Schema/ComputedFields/ComputedField (ADF)
Defining the Notification Schema
ComputedField Element (ADF)