Russian Qt Forum

         QSqlQuery insert_query;
         insert_query.prepare("INSERT INTO table1 (field1) VALUES (:field1)");
         insert_query.bindValue(":field1", "field1");         
         if (insert_query.exec())
         {
               QString sKey = QVariant(insert_query.lastInsertId()).toString();
          }

INSERT INTO table1 (field1) 
OUTPUT inserted.* 
VALUES (1)

QSqlQueryModel *model = new QSqlQueryModel;
model->setQuery(tr("exec proc1 "), database);
QTableView *view = new QTableView;
view->setModel(model);
view->show();

SCOPE_IDENTITY and @@IDENTITY will return last identity values generated in any table in the current session. However, SCOPE_IDENTITY returns values inserted only within the current scope; @@IDENTITY is not limited to a specific scope.

For example, you have two tables, T1 and T2, and an INSERT trigger defined on T1. When a row is inserted to T1, the trigger fires and inserts a row in T2. This scenario illustrates two scopes: the insert on T1, and the insert on T2 as a result of the trigger.

Assuming that both T1 and T2 have IDENTITY columns, @@IDENTITY and SCOPE_IDENTITY will return different values at the end of an INSERT statement on T1.

@@IDENTITY will return the last IDENTITY column value inserted across any scope in the current session, which is the value inserted in T2.

SCOPE_IDENTITY() will return the IDENTITY value inserted in T1, which was the last INSERT that occurred in the same scope. The SCOPE_IDENTITY() function will return the NULL value if the function is invoked before any insert statements into an identity column occur in the scope.

QSqlQuery sql(QSqlDatabase::database());
sql.exec("INSERT INTO someone VALUES (somefings); select SCOPE_IDENTITY()");

QSqlQuery sql(QSqlDatabase::database());
sql.exec("EXEC('INSERT INTO someone VALUES (somefings); select SCOPE_IDENTITY()')");
sql.next();
int id = sql.value(0).toInt();