What are the stored procedures?
Stored procedure is a collection of SQL statements that are stored on a SQL server. Its performance is better than the queries executed separately as the query plan is stored in the server which helps in executing the statements early. Variables can be passed into the procedure and we get back the out variable/ datasets. You can retrieve them whenever required