SQL Server Output Parameters: Understanding the Syntax

Published: 11 February 2013
on channel: LearnItFirst.com

4,030

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/Course161

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...

On this page of the site you can watch the video online SQL Server Output Parameters: Understanding the Syntax with a duration of hours minute second in good quality, which was uploaded by the user LearnItFirst.com 11 February 2013, share the link with friends and acquaintances, this video has already been watched 4,030 times on youtube and it was liked by 19 viewers. Enjoy your viewing!

3,390