NotificationClass.ComputedFieldSqlExpression Method

Artikel
12/15/2008

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

Namespace: Microsoft.SqlServer.NotificationServices
Assembly : Microsoft.SqlServer.NotificationServices (in microsoft.sqlserver.notificationservices.dll)

Syntax

'Declaration
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

Parameter

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

Rückgabewert

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

Hinweise

For more information about computed fields, see Definieren des Benachrichtigungsschemas.

Beispiel

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);

Threadsicherheit

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.

Plattformen

Entwicklungsplattformen

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Zielplattforme