Stored Procedures - An Introduction to Syntax, Concepts and Usage - Video Series Video Category: Transact-SQL Basics: Stored Procedures, Functions, Triggers and more Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 This series of videos (five in all) is designed for those of you who are new to working with stored procedures. It is a feature-complete overview with details on what stored procedures are, how they work, reasons for using them (vs. a view or similar object), and goes into the details of the advanced features such as OUTPUT parameters and @RETURN_VALUE. If you are wanting to become a serious SQL developer then this series is a must.

Videos in this Series:

Title Skill Length Download Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage   200 19 mins. Download Pt. 2 - CREATE PROCEDURE Syntax and Execution   200 13 mins. Download Pt. 3 - Input Parameters and Variables   200 10 mins. Download Pt. 4 - OUTPUT Parameters and How to Use Them   200 22 mins. Download Pt. 5 - RETURN Codes and How to Use Them   200 14 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Tracert ("trace route") is a great command-line tool that you can use to trace the path that an Internet Protocol (IP) packet takes from the source to the destination. Tracert is a great tool for determining if a hub/router/switch is down or having problems Book You Should Probably Own: Ken Henderson's "The Guru's Guide to SQL Server Stored Procedures, XML, and HTML" Book You Should Probably Own: Ken Henderson's "The Guru's Guide to Transact-SQL"