Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact-SQL Programming and Query Writing Training Videos
Transact SQL Videos in Series Home  Subscriber Videos  

Stored Procedures - An Introduction to Syntax, Concepts and Usage (Video Series)

Video Image Video Category: Stored Procedure Programming, Error Handling, and Passing Resultsets to the Client

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:


Miscellaneous Bits & Pieces:
Helpful Keyboard Shortcuts: "Windows key" + "M" minimizes all windows
Book You Should Probably Own: Ken Henderson's "The Guru's Guide to SQL Server Stored Procedures, XML, and HTML"
Want to see something cool? Run DBCC OPENTRAN (<insert your database name here >) WITH TABLERESULTS to view the most recent transaction details

Other Websites We Offer
LearnVBProgramming.com
Don't Forget!
100% Money Back Guarantee
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© 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. Refer a Friend and Get a Free Subscription!
 
1/8/2009 2:59:38 PM