What are stored procedures and when are they used?

Question

Accepted Answer

Stored procedures are precompiled SQL code that can be executed to perform operations on a database.

Stored procedures encapsulate complex SQL queries for reuse.
They improve performance by reducing the amount of information sent between the application and the database.
Example: A stored procedure to calculate total sales: CREATE PROCEDURE CalculateTotalSales AS SELECT SUM(SalesAmount) FROM Sales;
Stored procedures can accept parameters, allowing for dynamic execution.
Example: CREATE PROCEDURE GetEmployeeByID @EmployeeID INT AS SELECT * FROM Employees WHERE ID = @EmployeeID;

Accepted Answer

A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDBMS). Such procedures are stored in the database

Asked in TCS and 11 others

What are stored procedures and when are they used?

Interview Questions from Popular Companies