Stored Procedure
- It is a precompiled set of one or more SQL statements that is stored on Sql Server.
- As Stored Procedures are executed on the server side and perform a set of actions, before returning the results to the client side, which 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.
- 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 or Delete data in database.
