Summary
Stored procedures are a powerful way to implement reuse and consistency in an application. Data processed by a stored procedure can be used in various ways and is a great option for everything from returning the results of a basic SELECT statement to performing complex calculations. Parameterization is the key benefit of a stored procedure, enabling a single procedure to return different data based on the value of the passed parameters.
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
