Video:
Pt. 1 - What Output Parameters Are and When to Use Them
Skill
level:
200 (Beginner - Intermediate)- Run Time:
9:56
- Instructor:
Scott Whigham
Description:
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?
Download
and watch this video
NOTE: You will need the TSCC codec
installed to view video
Scott Whigham
Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive
video training libraries focusing on technical training. Scott is also an experienced
consultant, trainer, and author with more than a decade of hands-on experience working
with SQL Server databases, writing and debugging applications using Visual Studio,
and performance tuning. Scott designed the architecture (websites, class libraries,
and database) for the LearnItFirst.com websites and, most
re...
(Scott's full bio can be found here)
|
Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys
|
200
|
Download
|
|
Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs
|
300
|
Download
|
|
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause
|
300
|
Download
|
|
JOINs - An Overview of the Five Types of JOINs (Cross, Outer, and Inner)
|
200
|
Download
|
|
Rapid Database Development Using Database Diagrams (SQL Server 2000)
|
100
|
Download
|
NOTE: This video is part of our
SQL Server Programming (SQL Server 2005/2000): Transact SQL course.
This video is from Chapter
11:
Stored Procedure Programming and Error Handling
