Using Named Parameters

The Sybase data provider supports naming parameters when calling stored procedures. An application can use named parameters by specifying the Name property of a parameter as @xxx, where xxx can be any character. The name specified must match the name given in the Create Procedure statement for the parameter.

When using named parameters, all parameters in the stored procedure must be named. Suppose, however, the stored procedure was created with default values for some or all of the parameters. In this case, the application only needs to specify SybaseParameter objects for parameters that use the non-default values.

The Sybase data provider provides a mechanism for parameters to be bound using native syntax either ordinally or by name (see the Parameter Mode connection string option).

The Sybase data provider uses "@" to support named parameters in stored procedure calls, for example:

UPDATE emp SET job = @job, sal = @sal WHERE empno = @empno

When using the native syntax, the order of the named parameters does not matter.