Using Output Parameters in Your SQL Server Stored Procedures - Video Series Video Category: Transact-SQL Basics: Queries, Stored Procedures, Functions and more Skill Level: 300 (Intermediate) Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 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. NOTE: This video series was shot using SQL Server 2005 but the concepts are the same for all versions of SQL Server.

Videos in this Series:

Title Skill Length Download Pt. 1 - What Output Parameters Are and When to Use Them   200 10 mins. Download Pt. 2 - Using Output Parameters To Pass Data To the Caller   300 9 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Helpful Keyboard Shortcuts: "CTRL" + "SHIFT" highlights a block of text when used with the arrow keys Performance Tip: TRUNCATE TABLE is much faster than DELETE when removing all rows from a table. One caveat: TRUNCATE TABLE cannot be run on a table with foreign keys Helpful Keyboard Shortcuts: "ALT" + "F4" closes the application or, if no applications are open, prompts you to shutdown/log off