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.learnitfirst.com/Course/150/Video/514/Using-Ouput-Parameters-to-Pass-Data-to-Caller.aspx
- Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx
- Skill Level: 300 (Intermediate)
- Length: 09:11 (8.66MB)
- Full Details
To 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.