What is Store Procedure in SQL?

Answer 1

A group different queries, statement and combination functions under a single Name. like we have a batch file

Answer 2

Stored procedure is a pre-compiled set of one or more SQL statements that is stored on Sql Server. Benefit of Stored Procedures is that they are executed on the server side and perform a set of actions, before returning the results to the client side. This allows a set of actions to be executed with minimum time and also reduce the network traffic. Hence stored procedure improve performance to execute sql statements. For more about stored procedure refer the article CRUD Operations using Stored Procedures.
Stored procedure can accepts input and output parameters. Stored procedure can returns multiple values using output parameters. Using stored procedure, we can Select,Insert,Update,Delete data in database.