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:
Performance Tip: Don't apply the "Auto Shrink" database option for a production database. Auto Shrink is very expensive and can negatively impact the performance of your live system
Book You Should Probably Own: Joe Celko's "SQL for Smarties"
Performance Tip: The Transact-SQL command BULK INSERT is likely to be faster than the bulk copy program (bcp) because BULK INSERT runs in-process with SQL Server.

Other Websites We Offer
LearnCSharp.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:02 PM