select field1,field2 from SomeTable

if 3=3
	select field1,field2 from SomeTable

CREATE TABLE [dbo].[SomeTable](
	[field1] [uniqueidentifier] NOT NULL DEFAULT (newid()),
	[field2] [varchar](50) COLLATE Cyrillic_General_CI_AS NOT NULL DEFAULT ('')
	
) ON [PRIMARY]

insert into SomeTable (field2) values ('test1')
insert into SomeTable (field2) values ('test2')
insert into SomeTable (field2) values ('test3')

CREATE PROCEDURE [dbo].[teststorproc]
AS
BEGIN
if 3=3
	select * from SomeTable
END

#include <QtCore>
#include <QtGui>
#include <QtSql>


int main(int argc, char *argv[])
{
    QTextCodec *codec = QTextCodec::codecForName("cp1251");
    QTextCodec::setCodecForTr(codec);

    QApplication app(argc, argv);

    QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");

    QString connString;
    connString="DRIVER={SQL Server};" ;
    connString=connString+"Server=servername;" ;
    connString=connString+"Database=dbname;" ;
    connString=connString+"Uid=user;Pwd=pass;";
    db.setDatabaseName(connString);

    if (db.open())
           QMessageBox::information(0,QObject::tr("Информация"),
                                    QObject::tr("Соединение установлено !"));
        else
            {
                QMessageBox::critical(0,
                                  QObject::tr("Ошибка"),
                                  QObject::tr("Не удалось подключиться к базе данных!\n")+
                                      QObject::tr("Ошибка :")+db.lastError().text()
                                  );
                 return 0;
            }

    QSqlQuery *mainQuery;
    QSqlQueryModel *viewModel;

    mainQuery = new QSqlQuery;
    viewModel = new QSqlQueryModel;

    QString sqlString;
    sqlString = "exec teststorproc";

    mainQuery->prepare(sqlString);
    mainQuery->setForwardOnly(true);
    mainQuery->exec();
    if (mainQuery->lastError().isValid())
        {
            QMessageBox::critical(0,
                              QObject::tr("Ошибка"),
                              QObject::tr("Ошибка запроса!\n")+
                                  QObject::tr("Ошибка :")+mainQuery->lastError().text()
                              );
            return 0;
        }
    viewModel->setQuery(*mainQuery);

    while (viewModel->canFetchMore())
        viewModel->fetchMore();

    QTableView *tblView;
    tblView = new QTableView;
    tblView->setSelectionMode(QAbstractItemView::SingleSelection);
    tblView->setModel(viewModel);
    tblView->show();

    return app.exec();
}

    QString sqlString;
    sqlString = "{CALL teststorproc (?)}";
    mainQuery->prepare(sqlString);
    mainQuery->bindValue(0,"2");

    mainQuery->setForwardOnly(true);
    mainQuery->exec();

CREATE PROCEDURE [dbo].[teststorproc]
@param varchar(10)
AS
BEGIN
--	SET NOCOUNT ON

--if 3=3
select * from SomeTable
where field2 like('%'+ltrim(rtrim(@param))+'%')
END