Learn more about SQL Server tools

   
   























Latest SQL Server Tips














Free SQL Server Learning

Get your SQL Server in shape this Spring with Spotlight on SQL Server

 

Accidental DBA or DBA We've got You Covered with SQL Diagnostic Manager

Upgrade Strategies for Highly Available SQL Server Environments

Avoiding, Detecting, and Repairing SQL Server Database Corruption















SQL Server Stored Procedure

(Introduction)


Overview

A stored procedure is nothing more than prepared SQL code that you save so you can reuse the code over and over again.  So if you think about a query that you write over and over again, instead of having to write that query each time you would save it as a stored procedure and then just call the stored procedure to execute the SQL code that you saved as part of the stored procedure.

In addition to running the same SQL code over and over again you also have the ability to pass parameters to the stored procedure, so depending on what the need is the stored procedure can act accordingly based on the parameter values that were passed.

Take a look through each of these topics to learn how to get started with stored procedure development for SQL Server.

You can either use the outline on the left or click on the arrows to the right or below to scroll through each of these topics.

 







 
Sponsor Information