This chapter comes from our "SQL Server 2000 Database Administration" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Chapter 8: TSQL Programming: Stored Procedures, Variables, Functions and Triggers

This chapter is all about stored procedure programming, Error Handling, and passing resultsets to the client by various means as well as writing triggers (AFTER/INSTEAD OF), functions (scalar and table-valued UDFs), and TSQL variables.

Videos in Chapter 8

1	Variables and Scoping - Local Variables and Batch Terminators	Download
2	Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY	Download
3	Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage	Download
4	Pt. 2 - CREATE PROCEDURE Syntax and Execution	Download
5	Pt. 3 - Input Parameters and Variables	Download
6	Pt. 4 - OUTPUT Parameters and How to Use Them	Download
7	Pt. 5 - RETURN Codes and How to Use Them	Download

Login

Chapter 8: TSQL Programming: Stored Procedures, Variables, Functions and Triggers

Videos in Chapter 8