NotificationClass.ComputedFieldSqlExpression Method

Artículo
12/15/2008

Returns the Transact-SQL expression used to compute the value for a computed field.

Espacio de nombres: Microsoft.SqlServer.NotificationServices
Ensamblado: Microsoft.SqlServer.NotificationServices (in microsoft.sqlserver.notificationservices.dll)

Sintaxis

'Declaración
Public Function ComputedFieldSqlExpression ( _
    fieldOrdinal As Integer _
) As String

public string ComputedFieldSqlExpression (
    int fieldOrdinal
)

public:
virtual String^ ComputedFieldSqlExpression (
    int fieldOrdinal
) sealed

public final String ComputedFieldSqlExpression (
    int fieldOrdinal
)

public final function ComputedFieldSqlExpression (
    fieldOrdinal : int
) : String

Parámetros

fieldOrdinal
The zero-based ordinal of a developer-defined computed field in the notification class.

Valor devuelto

A string containing the Transact-SQL expression defined for the computed field when developing the application.

Notas

For more information about computed fields, see Definir el esquema de notificación.

Ejemplo

Dim instanceName As String = "MyInstanceName"
Dim applicationName As String = "MyApplicationName"
Dim notificationClassName As String = "MyNotificationClassName"
Dim fieldOrdinal As Integer = 0

'Create an NSInstance object.
Dim myInstance As New NSInstance(instanceName)

'Create an NSApplication object.
Dim myApplication As New NSApplication(myInstance, applicationName)

'Create a NotificationClassEnumeration object.
Dim myNotificationClassEnumeration As New _
    NotificationClassEnumeration(myApplication)

'Use the NotificationClassEnumeration.Item 
'to return a NotificationClass object.
Dim myNotificationClass As NotificationClass = _
    myNotificationClassEnumeration(notificationClassName)

'Use the ComputedFieldSqlExpression method to get a computed 
'field's Transact-SQL expression.
Dim sqlExpression As String = _
    myNotificationClass.ComputedFieldSqlExpression(fieldOrdinal)

string instanceName = "MyInstanceName";
string applicationName = "MyApplicationName";
string notificationClassName = "MyNotificationClassName";
int fieldOrdinal = 0;

//Create an NSInstance object.
NSInstance myInstance = new NSInstance(instanceName);

//Create an NSApplication object.
NSApplication myApplication = 
    new NSApplication(myInstance, applicationName);

//Create a NotificationClassEnumeration object.
NotificationClassEnumeration myNotificationClassEnumeration = 
    new NotificationClassEnumeration(myApplication);

//Use the NotificationClassEnumeration.Item 
//to return a NotificationClass object.
NotificationClass myNotificationClass = 
    myNotificationClassEnumeration[notificationClassName];

//Use the ComputedFieldSqlExpression method to get a computed 
//field's Transact-SQL expression.
string sqlExpression = 
    myNotificationClass.ComputedFieldSqlExpression(
    fieldOrdinal);

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