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
)

Параметры

• 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 Идентификаторы.

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)

Платформы

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

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

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

Список поддерживаемых платформ см. в разделе 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)
Определение схемы уведомления
ComputedField Element (ADF)