What is a stored procedure and its advantage?

Stored Procedure is a function which contain collection of SQL Queries. Procedure can take inputs , process them and send back output.

Stored Procedures are pre-complied and stored in database. This enable the database to execute the queries much faster. Since many queries can be included in a stored procedure, round trip time to execute multiple queries from source code to database and back is avoided.

Leave a Comment

Your email address will not be published. Required fields are marked *