A stored procedure in SQL is a group of SQL statements that are stored together in a database. Based on the statements in the procedure and the parameters you pass, it can perform one or multiple DML operations on the database, and return value, if any

A stored procedure is a prepared SQL code that can be saved and reused several times. So, if you have a SQL query that you write repeatedly, save it as a stored procedure and just call it to execute it.