Hello. This function is a part of MSSQLServer compatibility mode and is not available in other modes anymore.
For identity columns In Regular mode you need to ask an insert or merge operation about the inserted data. With JDBC you can use Statement.getGeneratedKeys() if Statement.RETURN_GENERATED_KEYS, column names, or column indexes were specified earlier. With SQL only you can use standard data change delta tables: SELECT ID FROM FINAL TABLE (INSERT INTO TEST (A, B) VALUES (1, 2)) https://h2database.com/html/grammar.html#data_change_delta_table If you have separate sequences, you can use non-standard and non-portable VALUES CURRENT VALUE FOR sequenceName but normally you should only use standard NEXT VALUE FOR sequenceName when new generated value is needed. https://h2database.com/html/grammar.html#sequence_value_expression -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/f7c28a61-e758-4e0c-bdd8-e49f2d75adddn%40googlegroups.com.
