NotificationClass.NotificationComputedFields Property
Gets the collection of computed fields for the notification class.
네임스페이스: Microsoft.SqlServer.Management.Nmo
어셈블리: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
구문
‘선언
Public ReadOnly Property NotificationComputedFields As NotificationComputedFieldCollection
public NotificationComputedFieldCollection NotificationComputedFields { get; }
public:
property NotificationComputedFieldCollection^ NotificationComputedFields {
NotificationComputedFieldCollection^ get ();
}
/** @property */
public NotificationComputedFieldCollection get_NotificationComputedFields ()
public function get NotificationComputedFields () : NotificationComputedFieldCollection
속성 값
A NotificationComputedFieldCollection object that represents the collection of computed fields for the notification class.
주의
Computed fields, which are optional, use Transact-SQL expressions to compute notification data immediately before the content is passed to the content formatter.
예
The following examples show how to define a computed field and then add it to the collection of computed fields 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)
스레드 보안
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
플랫폼
개발 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
대상 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
참고 항목
참조
NotificationClass Class
NotificationClass Members
Microsoft.SqlServer.Management.Nmo Namespace