This video is from our "SQL Server Programming (SQL Server 2005/2000): Transact SQL" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Video: Pt. 2 - Using Return Values to Control Program Execution

Skill level: 200 (Beginner - Intermediate)
Run Time: 9:40
Instructor: Scott Whigham

Description:

This video expands on the use of return values in SQL Server and shows you how to make decisions in your code based on a stored procedure's return value.

Highlights from this video:

What value does RETURN return by default?
What are the most likely conventions/uses of RETURN?
Using RETURN to return @@ERROR and SQL error codes
Best Practices for stored procedure programming

Download and watch this video

NOTE: You will need the TSCC codec installed to view video

Instructor
Related Videos
Related Courses
Other Videos in this Chapter

Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)

Video titleSkill

Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys	200	Download
Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs	300	Download
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause	300	Download
JOINs - An Overview of the Five Types of JOINs (Cross, Outer, and Inner)	200	Download
Rapid Database Development Using Database Diagrams (SQL Server 2000)	100	Download

CourseRun TimeSkill Level

148 - SQL Server 2000 Database Administration	200-500	20+ hrs
152 - SQL Server 2005 Database Administration	200-500	30+ hrs
157 - SQL Server 2008 Database Administration	200-500	45+ hrs
154 - SQL Server 2005 Reporting Services	200-500	17+ hrs
153 - SQL Server 2005 Integration Services	200-500	31+ hrs

Chapter 11: Stored Procedure Programming and Error Handling

1	RAISERROR and Substitution Parameters - How to Customize Your Error Messages (SQL Server 2000)
2	Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures Using the Create Stored Procedure Wizard
3	Pt. 1 - What Output Parameters Are and When to Use Them
4	Pt. 2 - Using Output Parameters To Pass Data To the Caller
5	Pt. 1 - What Return Values Are and How to Use Them
	Pt. 2 - Using Return Values to Control Program Execution
7	Pt. 3 - Best Practices for Using Return Values
8	Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage
9	Pt. 2 - CREATE PROCEDURE Syntax and Execution
10	Pt. 3 - Input Parameters and Variables
11	Pt. 4 - OUTPUT Parameters and How to Use Them
12	Pt. 5 - RETURN Codes and How to Use Them

NOTE: This video is part of our SQL Server Programming (SQL Server 2005/2000): Transact SQL course.
This video is from Chapter 11: Stored Procedure Programming and Error Handling

Login

Video: Pt. 2 - Using Return Values to Control Program Execution

Description:

Scott Whigham