People are human.

SQL Stored Proceedures are repeatable functions.

Humans make typing mistakes, the best LLM AI is advanced enough to create stored proceedures without a type-o.

This is not a sales pitch, it's a short list of facts to start an article about why you should make an app for the os of your choice, SQL server of your choice, that makes stored proceedures.

If there ever was a time to use AI code, it is a least when you need the stored proceedure to be right.

Most of you that know what RESTful AI connection and a stored proceedure is there is'nt much need to go further.

For the rest of you interested, ask an AI to explain what im talking about. Mix both database schema and a restful and good base prompts for a console like app that will prompt you for the proceedure description. Run on the server with

something like ssms or whatever you use, review the AI output and make your next proceedure. Then call it and see if it does what you want, if sucessful, you will no longer have to worry about

stored proceedures or calling them for your projects.