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

Return Values and SQL Server Stored Procedures (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
Not only can using return values in your stored procedures boost your performance, using return values can make your logic flow much simpler. Nearly all intermediate-to-advanced SQL Server developers make use of return values and the more experienced front-end developers also know how to make things work with the SQL RETURN statement.

NOTE: This video series was shot using SQL Server 2005 but the concepts are the same for all versions of SQL Server.

Videos in this Series:


Miscellaneous Bits & Pieces:
After SQL Server 2000 you should not be using @@IDENTITY in your code. Microsoft replaced @@IDENTITY with SCOPE_IDENTITY() in SQL Server 2000
You can disable the "sa" account by setting your SQL Server security mode to Windows Authentication Only. You will still have an "sa" account but it will not be able to log in to your SQL Server
Book You Should Probably Own: Rob Viera's "Beginning SQL Server 2005 Programming"

Other Websites We Offer
LearnSqlServer.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!
 
11/20/2008 6:20:32 PM