MSSQL documentation: Binding a variable to a query

[joshbenaron]

Hey,

I'm trying to bind a variable to a query like so:

#[derive(sqlx::FromRow)]
struct Test {
    BOOKING_TYPE_ID: String,
    BOOKING_TYPE: String,
    DESCRIPTION: String,
}

let row = sqlx::query_as::<_, Test>("SELECT * FROM BOOKING_TYPE WHERE DESCRIPTION = ?)
        .bind("hio")
        .fetch_one(&state.sql_pool).await.unwrap();

This produces invalid SQL. I've also tried {0} and @p1 instead of ?. I'm just not sure what the syntax is.
I've noticed there is different syntax for MySql and Postgres but I see no documentation on MSSQL. So:

1. How do I bind to a query with MSSQL?
2. Also, what Rust data type relates to MSSQL's uniqueidentifier (GUID)?
3. I would be happy to contribute to the MSSQL documentation maybe with an example (I noticed there's only an example for MySql and Postgres)

[mehcode]

How do I bind to a query with MSSQL?

Currently the syntax is @p1 .. @p2, etc. This is standard MSSQL.

We are planning #419 which would make {0} work.

---

We do not support GUIDs in MSSQL yet. Unfortunately, our MSSQL support is still very much alpha-quality at the moment.

[ondono]

Currently the syntax is @p1 .. @p2, etc. This is standard MSSQL.

Could we add this to the docs/usage guide in the meantime? I've spent a lot of time not understanding what was happening and I was about to bail out on sqlx altogether.

[Azmekk]

Currently the syntax is @p1 .. @p2, etc. This is standard MSSQL.

I would like to bump this as well. It would be nice to see this added to documentation since I also wasted a bunch of time like ondono.