What are the advantages a stored procedure?

Posted by

To view Verified answers click on the button below.

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.