[Qt-interest] QSqlQuery and placeholders of the same name

[Антон Сердюков]

I have found solution for MSSQL (in my case). Here it is.

-------------------------------------
QSqlQuery query;
query.prepare(
  "declare @param int;"
  "set @param = :param;"
  "select * from some_table where columnA > @param AND columnB = @param;"
  );

query.bindValue(":param", someValue);
query.exec();
-------------------------------------

Hope, that will help somebody.