Ah, ok. Thank you very much for the detailed answer! Evgenij Ryazanov schrieb am Mittwoch, 8. Dezember 2021 um 01:33:17 UTC+1:
> 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/0eae0807-b358-42f9-95b2-2da1ce53dbbdn%40googlegroups.com.
