What Is a Stored Procedure and Why Use it? - SQL Server

An SQL Server Stored Procedure is a logical collection of statements or queries packaged together to perform a particular task, repeatedly. You do not have to write the statements repeatedly and it saves not just time but also other server resources.

Continue reading...