A SQL Server stored procedure, sometimes referred to as a stored proc or procedure, allows you to write one or more TSQL statements and store them within your database so that they can be called over and over again without having to write that code a again. This article shows you how to create a stored procedure for the Microsoft SQL Server database.
This article is based on Learn SQL Server 2012 in a Month of Lunches, to be published in the Fall 2012. It is being reproduced here by permission ...