Get the last inserted row ID SAP Hana db (database)

May 04, 2017 758
get-the-last-inserted-row-id-sap-hana-db-database

If your SAP Hana table has a column of type INT IDENTITY (or BIGINT IDENTITY), then you can get the latest inserted value using: INSERT INTO dbo.YourTable(columns....) VALUES(..........) select current_identity_value() FROM DUMMY; This works as long as you haven't inserted another row - it just returns the last&nbs...

MORE...