Different options for creating SQL Server stored procedures

Overview

There are various options that can be used to create stored procedures.  In these next few topics we will discuss creating a simple stored procedure to more advanced options that can be used when creating stored procedures.

Explanation

Some of the topics we will cover include:

• Creating a simple stored procedure
• Using input parameters
• Using output parameters
• Using Try Catch