NotificationClass.ComputedFieldSqlExpression Method

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

命名空間: Microsoft.SqlServer.NotificationServices
組件: Microsoft.SqlServer.NotificationServices (in microsoft.sqlserver.notificationservices.dll)

語法

'宣告
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

參數

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

傳回值

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

備註

For more information about computed fields, see 定義通知結構描述.

範例

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

執行緒安全性

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.NotificationServices Namespace