Stored Procedures - An Introduction to Syntax, Concepts and Usage - Video Series Video Category: Transact-SQL Basics: Queries, Stored Procedures, Functions 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:

SQL Server 2000 Service Pack 4 Features: Changes were made to the visual tools: the table designer, the diagrams, and the Query Designer which make them more secure and reliable Helpful Tools for your SQL Server: Check out Microsoft's Best Practices Analyzer Tool - a free download from microsoft.com/sql You can use the "SQL Server 2000 Web Services Toolkit" to work with XML Data and web services with your SQL Server. Check out Microsoft's Download page and search for "SQL Server 2000 Web Services Toolkit" for more