SQL Server 7 has a special database value known as @@identity which equals the value of the primary key field for the newly inserted record. The stored procedure then uses the @@identity value as the ...

A more complicated T-SQL stored procedure might use multiple SQL statements, ... Operating on Data in SQL, Creating Tables in SQL, ... Oracle Database, SQL Server, SQLite, and IBM DB2. W3Schools.

Calling SQL Server Stored procedures in Power Apps. I created a little demo app. (Yes, it doesn’t look good and wouldn’t pass my QA tests). On the top left I can add cars.