A SQL Query is great for direct questions to the database, but what if you needed to perform some action that was not just a direct question to the database? Perhaps a security or database integrity process
This is where Stored Programs come into play, they are programs that can provide the ability to write code between Queries, Interfaces and API’s
Using Stored Programs we are starting to bridge the gap between external programming and SQL Queries