Thursday, November 16, 2006

New Transact SQL Video Tutorial: Pt. 3 - Input Parameters and Variables

Pt. 3 - Input Parameters and Variables - view details
The bulk of your stored procedures will be dynamic, meaning that they will have parameters and those parameters will be used to make decisions (such as what rows to return). This video talks about how to create parameters and variables as well as working with default parameters ( to make a parameter optional instead of required, for example).
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 must have the TSCC codec installed to view this video

posted by Scott Whigham @ 4:27 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 2 - CREATE PROCEDURE Syntax and Execution

Pt. 2 - CREATE PROCEDURE Syntax and Execution - view details
This video walks you through the essential syntax elements of the CREATE PROC (or CREATE PROCEDURE if you prefer) statement and also helps you understand how to execute stored procs. At the end of this video, you'll also learn how to modify (ALTER) and remove (DROP) stored procedures.
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 must have the TSCC codec installed to view this video

posted by Scott Whigham @ 4:27 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 4 - OUTPUT Parameters and How to Use Them

Pt. 4 - OUTPUT Parameters and How to Use Them - view details
One of the more confusing aspects of the stored procedure is the syntax and usage of OUTPUT parameters. This video tutorial will help you understand what OUTPUT params are, where they are used (in a Singleton pattern, for example), and how to access/assign the values to local variables. Don't miss this video!
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 must have the TSCC codec installed to view this video

posted by Scott Whigham @ 4:27 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage

Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage - view details
Stored procedures are the way of the modern programmer and this first video in this series helps you understand the need for and the use of stored procedures in modern applications. You'll learn the basic syntax elements, where to use stored procs, who uses them, and see some rather intricate examples of usage.
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 must have the TSCC codec installed to view this video

posted by Scott Whigham @ 4:27 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 5 - RETURN Codes and How to Use Them

Pt. 5 - RETURN Codes and How to Use Them - view details
The last video in our "Introduction to Stored Procedures" series, this video helps you understand the @RETURN_VALUE parameter when calling/executing stored procedures. The RETURN statement in SQL Server is very important - it allows you to stop execution inside a stored procedure or trigger. Did you know that it also has the ability to return a value to the caller? It sure can but there are certain rules and Best Practices. Check out this video for more!
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 must have the TSCC codec installed to view this video

posted by Scott Whigham @ 4:27 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 2 - Using Return Values to Control Program Execution

Pt. 2 - Using Return Values to Control Program Execution - view details
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
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 must have the TSCC codec installed to view this video

posted by Scott Whigham @ 4:16 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 3 - Best Practices for Using Return Values

Pt. 3 - Best Practices for Using Return Values - view details
The final video in this series on using return values talks about using RETURN to send @@ERROR values back to the caller and whether or not this is a common/good practice.

Highlights from this video:
  • Using RETURN with @@ERROR
  • Making Decisions with SqlParameter and ParameterDirection.ReturnValue
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 must have the TSCC codec installed to view this video

posted by Scott Whigham @ 4:16 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 2 - Using Output Parameters To Pass Data To the Caller

Pt. 2 - Using Output Parameters To Pass Data To the Caller - view details
This continues our discussion of OUTPUT parameters from Part 1. Please ensure that you have viewed Part 1 before watching this video.

Highlights from this video:
  • When to Use Output Parameters
  • Output Parameter or Result Set?
  • Passing Data Between Stored Procedures
  • Master-Detail Inserts with IDENTITY values
  • @@IDENTITY or SCOPE_IDENTITY?
  • OUT or OUTPUT?
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 must have the TSCC codec installed to view this video

posted by Scott Whigham @ 4:16 PM   0 comments  

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
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 must have the TSCC codec installed to view this video

posted by Scott Whigham @ 4:16 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 1 - What Output Parameters Are and When to Use Them

Pt. 1 - What Output Parameters Are and When to Use Them - view details
This video is a great introduction to using OUTPUT parameters. Modern SQL programmers use output parameters in so many stored procedures that it's tough to be a decent SQL developer without a solid understanding of how they work. This video series walks you through what OUTPUT parameters are, how they work, and gives you several business cases for how to use them effectively. Please note that this video needs to be downloaded with Part 2 of this series since the demo/discussion is completed in Part 2.

NOTE: This video series was shot using SQL Server 2005 but the concepts are the same for all versions of SQL Server.

Highlights from this video:
  • When to Use Output Parameters
  • Output Parameter or Result Set?
  • Passing Data Between Stored Procedures
  • Master-Detail Inserts with IDENTITY values
  • @@IDENTITY or SCOPE_IDENTITY?
  • OUT or OUTPUT?
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 must have the TSCC codec installed to view this video

posted by Scott Whigham @ 4:16 PM   0 comments  

Wednesday, November 08, 2006

New Transact SQL Video Tutorial: Variables and Scoping - Local Variables and Batch Terminators

Variables and Scoping - Local Variables and Batch Terminators - view details
Variables and Scoping - Local Variables and Batch Terminators
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 must have the TSCC codec installed to view this video

posted by Scott Whigham @ 7:56 AM   0 comments