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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/0eae0807-b358-42f9-95b2-2da1ce53dbbdn%40googlegroups.com.
