New Microsoft SQL Server Video Tutorial: Pt. 2 - Using Output Parameters To Pass Data To the Caller

Pt. 2 - Using Output Parameters To Pass Data To the Caller - view details

This continues our discussion of OUTPUT parameters from Part 1. Please ensure that you have viewed Part 1 before watching this video.

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.learnsqlserver.com
• Category: Transact-SQL Basics: Queries, Stored Procedures, Functions and more
• Skill Level: 300 (Intermediate)
• Length: 09:11 (8.66MB)
• 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

---

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