✏️ Explanatory Question

What is a stored procedure?

👁 484 Views
📘 Detailed Answer
💡

Answer with Explanation

A stored procedure is a pre-compiled set of one or more SQL statements that are stored on SQL Server. The benefit of Stored Procedures is that they are executed on the server-side and perform a set of actions, before returning the results to the client-side. This allows a set of actions to be executed with minimum time and also reduces the network traffic. Hence stored procedure improves performance to execute SQL statements.