NotificationComputedField Constructor (NotificationClass, String)
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)
'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
)
- notificationClass
The parent NotificationClass object for the computed field.
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 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.
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)
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
NotificationComputedField Class
NotificationComputedField Members
Microsoft.SqlServer.Management.Nmo Namespace
FieldName Element for NotificationClass/Schema/ComputedFields/ComputedField (ADF)
Defining the Notification Schema
ComputedField Element (ADF)