Store Procedure

Question

hi  Can any one Explain About What is stored Procedure Explain Briefly With Example Thank you

Bikesh Srivastava · Answer

Hi In a database management system (DBMS) a stored procedure is a set of Structured Query Language ( SQL ) statements with an assigned name that's stored in the database in compiled form so that it can be shared by a number of programs.

Dhananjay Kumar · Answer

A stored procedure is a group of sql statements that has been created and stored in the database. Stored procedure will accept input parameters so that a single procedure can be used over the network by several clients using different input data. Stored procedure will reduce network traffic and increase the performance. If we modify stored procedure all the clients will get the updated stored procedure http://www.codeproject.com/Articles/38682/Overview-of-SQL-Server-Stored-Procedure

Midhun T P · Answer

Hi A stored procedure is nothing more than prepared SQL code that you save so you can reuse the code over and over again. So if you think about a query that you write over and over again instead of having to write that query each time you would save it as a stored procedure and then just call the stored procedure to execute the SQL code that you saved as part of the stored procedure. In addition to running the same SQL code over and over again you also have the ability to pass parameters to the stored procedure so depending on what the need is the stored procedure can act accordingly based on the parameter values that were passed. Reference - https://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure-tutorial/ Also have a look at below link - http://www.aspdotnet-suresh.com/2011/07/what-is-stored-procedure-in-sql-server.html