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)

플랫폼

개발 플랫폼

지원되는 플랫폼 목록은 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)