Member of the
LearnItFirst.com Video Training Network
Related Video Training Sites:
·
SQL DTS Training Videos
·
SQL Programming Videos
Create a free account
·
Sign In
SQL Server 2000 Videos in Series
Home
Subscriber Videos
Stored Procedures - An Introduction to Syntax, Concepts and Usage (Video Series)
Video Category:
TSQL Programming: Stored Procedures, Variables, Functions and Triggers
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
Miscellaneous Bits & Pieces:
The scripts to rebuild the Northwind and Pubs database are included in the MSSQL\Install folder
Keyboard Shortcut for Query Analyzer: Shift+F1 brings up the context-sensitive help in Books Online
Helpful Tools for your SQL Server: Check out Microsoft's Best Practices Analyzer Tool - a free download from microsoft.com/sql
About Us
·
Corporate Philosophy
·
Advertise With Us
·
Become an Author
·
Contact Us
Video Playback
·
System Requirements
·
TSCC Codec
(to play videos)
·
Troubleshooting/Problems
Subscriptions
·
Pricing/Buy Now
·
Testimonials
·
Privacy
·
Terms of Service
More Video Training
·
SQL DTS Training Videos
·
SQL Programming Videos
·
All of Our Websites
More
·
FAQs
·
Search for videos
·
Site Map
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.
11/20/2008 2:14:13 PM