Member of the
LearnItFirst.com Video Training Network
Related Video Training Sites:
·
SSIS Training Videos
·
SQL Programming Tutorials
Create a free account
·
Sign In
SQL Server DBA Videos in Series
Home
Subscriber Videos
Return Values and SQL Server Stored Procedures (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
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:
Title
Skill
Length
Download
Pt. 1 - What Return Values Are and How to Use Them
200
10 mins.
Download
Pt. 2 - Using Return Values to Control Program Execution
200
10 mins.
Download
Pt. 3 - Best Practices for Using Return Values
300
9 mins.
Download
Miscellaneous Bits & Pieces:
Tips and Tricks: Microsoft's Baseline Security Analyzer (MBSA) is a great free tool for determining the attack surface area of your server
Keyboard Shortcut for Query Analyzer: CTRL+SHIFT+C comments out the highlighted text while CTRL+SHIFT+R removes comments
There are so many add-ons and downloads for SQL Server 2000 that it's impossible to list even a quarter of them here. Check out Microsoft's
Download page
, search for all downloads on SQL Server, and wow!
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
·
SSIS Training Videos
·
SQL Programming Tutorials
·
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.
8/28/2008 3:07:32 AM