Can we create stored procedure in retool

I was wondering how I can implement the stored procedure

You need to make your stored procedure in your database. And then call it within a query. Here is one of my queries for Azure SQL Sever:

EXEC CopyTemplate {{}};

This SP does not return anything and Retool seems fine with that. I have not yet used any SPs that return a dataset but I assume it will be treated like a SELECT query.

1 Like

Thank you, sir!