SQL Server Programming and Queries Training Video: Pt. 1 - What O utput Parameters Are and When to Use Them

Pt. 1 - What Output Parameters Are and When to Use Them - view details
This video is a great introduction to using OUTPUT parameters. Modern SQL programmers use output parameters in so many stored procedures that it's tough to be a decent SQL developer without a solid understanding of how they work. This video section walks you through what OUTPUT parameters are, how they work, and gives you several business cases for how to use them effectively. Please note that this video needs to be downloaded with Part 2 of this section since the demo/discussion is completed in Part 2.

NOTE: This video section was shot using SQL Server 2005 but the concepts are the same for all versions of SQL Server.

Highlights from this video:
When to Use Output Parameters
Output Parameter or Result Set?
Passing Data Between Stored Procedures
Master-Detail Inserts with IDENTITY values
@@IDENTITY or SCOPE_IDENTITY?
OUT or OUTPUT?
Source: http://www.learnitfirst.com/Course/150/Video/512/Intro-to-Output-Parameters.aspx Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx Skill Level: 200 (Beginner - Intermediate) Length: 9:56 (7.14MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: output, out params, sql parameters, sqlparameter, parameterdirection.output

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.