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

< Return to list of all videos

Miscellaneous Bits & Pieces:

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 Keyboard Shortcut for SQL Server Management Studio: CTRL+SHIFT+U converts text to uppercase Keyboard Shortcut for SQL Server Management Studio: SHIFT+F10 displays the context menu