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:

Keyboard Shortcut for SQL Server Management Studio: CTRL+SHIFT+U converts text to uppercase User-defined data types are handy ways to create shortcuts to commonly used data type conventions. You could, for example, create the user-defined data type "Emails" to use as the data type for any column that stores email addresses Helpful Keyboard Shortcuts: "Windows key" + "D" shows the desktop