Get the last inserted row ID SAP Hana db (database)
May 04, 2017
1735
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...