New Microsoft SQL Server Video Tutorial: Pt. 1 - What Output 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 series 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 series since the demo/discussion is completed in Part 2.

NOTE: This video series 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?

• Category: Transact-SQL Basics: Queries, Stored Procedures, Functions and more
• Skill Level: 200 (Beginner - Intermediate)
• Length: 9:56 (7.14MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

Note: You must have the TSCC codec installed to view this video