Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

SQL Server Output Parameters: Understanding the Syntax

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
5,393
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Mar 28, 2011

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

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (5)

Sign In or Sign Up now to post a comment!
  • @hassax1966 Thanks!

  • @tomatobird312 Awesome! Glad we could help. There's more where that came from!

  • dude !! been watching ur videos for while now !! and i can only say your are Gooood !!

  • Thanks very much for the video it cleared up my confusion

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more