GitHub

parameter

API reference for parameter.

Stored procedure parameters (Effect's @effect/sql-mssql Parameter): a name, the SQL Server type it is sent as, and the Python type of its value, which Parameter[A] carries::

answer = Parameter[int]("answer", TYPES.Int)
name = Parameter[str]("name", TYPES.NVarChar, ParameterOptions(length=50))

name("Tim") binds an input's value (Procedure.compile); the output of a call is read back with result.output[answer].

Classes