SQL Server Output Parameters: Understanding the Syntax

This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here:

Now onto one of Scott's least favorite (but one of the most useful!) syntaxes: the output parameter. The syntax can be confusing, but this video should help clarify many of the tricky aspects of working with output parameters. When and why would you want to use them?

Highlights from this video:

- Review of stored procedures
- What are output parameters?
- Output parameter syntax
- Capturing the value of an output parameter
- Can you have an "output only" output parameter?
- Using output parameters vs. returning the select statement

and much more...