NotificationClass.ComputedFieldSqlExpression Method

Article
12/15/2008

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

Espace de noms: Microsoft.SqlServer.NotificationServices
Assembly: Microsoft.SqlServer.NotificationServices (in microsoft.sqlserver.notificationservices.dll)

Syntaxe

'Déclaration
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

Paramètres

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

Valeur de retour

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

Notes

For more information about computed fields, see Définition du schéma de notification.

Exemple

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

Sécurité des threads

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles