Macro query_scalar 

macro_rules! query_scalar {
    ($query:expr) => { ... };
    ($query:expr, $($args:tt)*) => { ... };
}

Available on crate feature macros only.

Compile-time checked SQL query for MSSQL via ODBC, returning a single scalar value.

let count: i64 = sqlx_mssql_odbc::query_scalar!("SELECT COUNT(*) FROM users")
    .fetch_one(&mut conn)
    .await?;

let max_id: Option<i32> = sqlx_mssql_odbc::query_scalar!("SELECT MAX(id) FROM users")
    .fetch_optional(&mut conn)
    .await?;

Requires the macros feature.