New Transact SQL Video Tutorial: Pt. 1 - What Return Values Are and How to Use Them

Pt. 1 - What Return Values Are and How to Use Them - view details

This video is an excellent introduction to using Return Values in your SQL Server stored procedures. Return values can speed up performance of your applications as well as helping make a more logical flow. Anyone writing or maintaining stored procedures needs to know this information. NOTE: This video was shot on SQL Server 2005 but the same concepts apply to all versions of SQL Server.

Highlights from this video:

• Making decisions using return values
• Returning values to the caller
• Using RAISERROR and RETURN values

---

• Source: http://www.LearnTransactSQL.com
• Category: Stored Procedure Programming, Error Handling, and Passing Resultsets to the Client
• Skill Level: 200 (Beginner - Intermediate)
• Length: 9:32 (7.85MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You mu st have the TSCC codec installed to view this video

---

Keywords Associated with this video: SqlParameter, ParameterDirection.ReturnValue, returning error, return @@ERROR, @RETURN_VALUE