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...