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
@hassax1966 Thanks!
LearnItFirst 4 days ago
@tomatobird312 Awesome! Glad we could help. There's more where that came from!
LearnItFirst 4 days ago
dude !! been watching ur videos for while now !! and i can only say your are Gooood !!
hassax1966 1 month ago
Thanks very much for the video it cleared up my confusion
tomatobird312 5 months ago