Compartir a través de


FunctionValue Constructor (UserDefinedFunction, Argument[])

Initializes a new instance of the FunctionValue class with a user-defined function and the function parameters.

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

Sintaxis

'Declaración
Public Sub New ( _
    userDefinedFunction As UserDefinedFunction, _
    ParamArray parameters As Argument() _
)
public FunctionValue (
    UserDefinedFunction userDefinedFunction,
    params Argument[] parameters
)
public:
FunctionValue (
    UserDefinedFunction^ userDefinedFunction, 
    ... array<Argument^>^ parameters
)
public FunctionValue (
    UserDefinedFunction userDefinedFunction, 
    Argument[] parameters
)
public function FunctionValue (
    userDefinedFunction : UserDefinedFunction, 
    ... parameters : Argument[]
)

Parámetros

  • parameters
    Zero or more Argument objects that define the parameters for the user-defined function.

Notas

The user-defined function must have a scalar return type.

If you specify zero parameters, you must specify the function using the UserDefinedFunction property and you must specify the parameters for the function using the Parameters property.

Ejemplo

The following example shows the definition of a user-defined function, and then uses this function to evaluate events:

// Subscription based on the following function definition:

/*
create function SoundexMatch(@x nvarchar(max), @y nvarchar(max))
returns bit
as
begin
    if soundex(@x) = soundex(@y)
        return 1

    return 0
end
 * */

// Create subscription and define basic properties.
s = new Subscription(nsApplication, subscriptionClassName);
s.SubscriberId = "Richard";
s.Enabled = true;
s.RuleName = "InventoryTrackerRule";
s.SetFieldValue("DeviceName", "myDevice");
s.SetFieldValue("SubscriberLocale", "en-us");

// Define a condition that uses the function to evaluate
// if the condition is true.
s.Condition = new BooleanLeafCondition(new FunctionValue(
    db.UserDefinedFunctions["SoundexMatch", "dbo"],
    new FieldValue("ProductName"),
    "Rood-250 Black, 48"));

// Add subscription.
s.Add();

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

FunctionValue Class
FunctionValue Members
Microsoft.SqlServer.NotificationServices.Rules Namespace

Otros recursos

Funciones definidas por el usuario (motor de base de datos)