Can we create stored procedure in retool

Queries and Resources
1

I was wondering how I can implement the stored procedure

2

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 {{tblTemplates.selectedRow.data.template_id}};

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
3

Thank you, sir!