Syntax for SQL Server Output Parameters
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:
http://www.learnitfirst.com/Course/16...
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