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:

Security Tip: Run the Microsoft Baseline Security Analyzer (MBSA) on your SQL Server to ensure that you are well protected SQL Server 2000 Resource Kit - More Helpful Tools: SQL DMO has many nice examples of using DMO to script your SQL Server administration Performance Tip: Defragmenting your SQL Server indexes is an essential management component. Most DBAs schedule their index defragmentation at least once per month and perhaps as often as once per week depending on system delta