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.