Question: what are the advantages of using stored procedures?
Answer: To help you build powerful database applications, stored procedures provide several advantages including better performance, higher productivity, ease of use, and increased scalability. ...  Additionally, stored procedures enable you to take advantage of the computing resources of the server.