NotificationClass.NotificationComputedFields Property
Gets the collection of computed fields for the notification class.
Espacio de nombres: Microsoft.SqlServer.Management.Nmo
Ensamblado: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Sintaxis
'Declaración
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
Valor de propiedad
A NotificationComputedFieldCollection object that represents the collection of computed fields for the notification class.
Notas
Computed fields, which are optional, use Transact-SQL expressions to compute notification data immediately before the content is passed to the content formatter.
Ejemplo
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)
Seguridad para subprocesos
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.
Plataformas
Plataformas de desarrollo
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Plataformas de destino
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Vea también
Referencia
NotificationClass Class
NotificationClass Members
Microsoft.SqlServer.Management.Nmo Namespace
Otros recursos
ComputedFields Element (ADF)
Definir el esquema de notificación
Definir clases de notificación