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/161/SQL-Programming-2008.aspx?an=YouTube

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

Category:

Science & Technology

Tags:

• sql
• sql server
• 2008
• r2
• instruction
• training
• lesson
• output parameter
• output parameter syntax
• stored procedure
• select statement