Struct ProcedureBuilder 

pub struct ProcedureBuilder<'a, S: ConnectionState> { /* private fields */ }

Builder for constructing stored procedure calls with named parameters.

Created via Client::procedure(). Supports both input and output parameters with type-safe output declarations.

Example

let result = client.procedure("dbo.CalculateSum")?
    .input("@a", &10i32)
    .input("@b", &20i32)
    .output_int("@result")
    .execute().await?;

// Access the output parameter
let output = result.get_output("@result").expect("output param present");
assert_eq!(output.value, SqlValue::Int(30));

Implementations

impl<'a, S: ConnectionState> ProcedureBuilder<'a, S>

pub fn input(&mut self, name: &str, value: &(dyn ToSql + Sync)) -> &mut Self

Add a named input parameter.

The name should include the @ prefix (e.g., "@id"). The value is converted using the same logic as query parameters.

Example

client.procedure("dbo.UpdateUser")?
    .input("@id", &42i32)
    .input("@name", &"Alice")
    .execute().await?;

pub fn output_int(&mut self, name: &str) -> &mut Self

Add a named output parameter of type INT.

Example

client.procedure("dbo.GetCount")?
    .output_int("@count")
    .execute().await?;

pub fn output_bigint(&mut self, name: &str) -> &mut Self

Add a named output parameter of type BIGINT.

pub fn output_nvarchar(&mut self, name: &str, max_len: u16) -> &mut Self

Add a named output parameter of type NVARCHAR with the given max length.

Use max_len = 0 for NVARCHAR(MAX).

pub fn output_bit(&mut self, name: &str) -> &mut Self

Add a named output parameter of type BIT.

pub fn output_float(&mut self, name: &str) -> &mut Self

Add a named output parameter of type FLOAT (64-bit).

pub fn output_decimal( &mut self, name: &str, precision: u8, scale: u8, ) -> &mut Self

Add a named output parameter of type DECIMAL with given precision and scale.

pub fn output_raw(&mut self, name: &str, type_info: RpcTypeInfo) -> &mut Self

Add a named output parameter with a raw TypeInfo for uncommon types.

This is an escape hatch for types not covered by the typed output methods.

Example

use tds_protocol::rpc::TypeInfo;

client.procedure("dbo.GetGuid")?
    .output_raw("@id", TypeInfo::uniqueidentifier())
    .execute().await?;

pub async fn execute(&mut self) -> Result<ProcedureResult>

Execute the stored procedure and return the result.

Sends an RPC request to SQL Server with the accumulated parameters and reads the complete response including result sets, output parameters, and the procedure return value.