SQL Server 2008 Analysis Services Training Video: Creating and Ma naging Table Variables

Creating and Managing Table Variables - view details
Table variables have the same syntax and logic as permanent tables, but the scope is different. Where are variables stored? What does GO do? This video focuses on why the scope difference is so important, and when you should use table variables.

Highlights from this video:Table variable syntaxVariable scope
Is it faster to write to a hard drive or to memory?
Inserting into a table variable
and much more Source: http://www.learnitfirst.com/Course/161/Video/2925/Table-Variables.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 300 (Intermediate) Length: 8:15 (18.7MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: table, variable, permanent, temporary, scope

This video comes from the SQL Server 2008 Analysis Services online training course, Transact-SQL Programming: SQL Server 2008/R2. And be sure to check out even more SQL Server Analysis Services training videos.