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.

#3

Thank you, sir!