LearnItFirst.com: Free Training Videos: Free Transact SQL Video Tutorial: Design Pattern for Looping Through Rows and Executing A Stored Procedure

LearnItFirst.com: Free Training Videos

Every time we post a new free training video on any site in the LearnItFirst.com Video Training Network, we'll post it here as well. Add this feed into your RSS newsreader so that you'll be notified for each free video. You'll find videos on SQL Server 2005, Windows 2003, Windows Vista, Exchange Server, .NET, Visual Studio, ASP.NET and much, much more

Thursday, November 16, 2006

Free Transact SQL Video Tutorial: Design Pattern for Looping Through Rows and Executing A Stored Procedure - Using a Temporary Table

Design Pattern for Looping Through Rows and Executing A Stored Procedure - Using a Temporary Table - download

Another great video in our Design Pattern series, this video tutorial focuses on how to iterate through a resultset and execute a stored procedure for each of the row values. Example: let's say you wanted to execute SP_HELPDB for every database on your server. You could write the code by hand by entering EXEC SP_HELPDB master; EXEC SP_HELPDB msdb; etc. The problem? This is not a dynamic approach so any new databases added after your script would not be included. The technique in the video uses temp tables for iteration.

Category: SQL Server Videobooks
Skill Level: 400 (Intermediate - Advanced)
Length: 14:43 (10.4MB)
Source Videobook Entry (Subscriber-only version)

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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