Share via

SqlInputOptions interface

  • Reference
Package:
@azure/functions

Properties

commandText

The Transact-SQL query command or name of the stored procedure executed by the binding.
commandType

The command type value
connectionStringSetting

An app setting (or environment variable) with the connection string for the database against which the query or stored procedure is being executed
parameters

Zero or more parameter values passed to the command during execution as a single string. Must follow the format @param1=param1,@param2=param2. Neither the parameter name nor the parameter value can contain a comma (,) or an equals sign (=).

Property Details

commandText

The Transact-SQL query command or name of the stored procedure executed by the binding.

commandText: string

Property Value

string

commandType

The command type value

commandType: "Text" | "StoredProcedure"

Property Value

"Text" | "StoredProcedure"

connectionStringSetting

An app setting (or environment variable) with the connection string for the database against which the query or stored procedure is being executed

connectionStringSetting: string

Property Value

string

parameters

Zero or more parameter values passed to the command during execution as a single string. Must follow the format @param1=param1,@param2=param2. Neither the parameter name nor the parameter value can contain a comma (,) or an equals sign (=).

parameters?: string

Property Value

string