New Transact SQL Video Tutorial: The Differences Between Local Temporary Tables and Global Temp Tables and When to Use Each

The Differences Between Local Temporary Tables and Global Temp Tables and When to Use Each - view details

Temporary tables are essential knowledge for all TSQL developers and you should know (a) the differences between the local temp tables (#MyTable) and global temp tables (##MyTable), and (b) when and where to use each. This video gives you the details about each type of temporary table and best practices for using them. Also included is an architecture discussion of how temp tables work and a peek inside the tempdb system database.

Highlights from this video:

• When to use local temp tables or global temp tables
• Naming clashes with temp tables
• Syntax for creating temporary tables
• Scoping of temp tables
• Passing temporary tables (result sets) between stored procedures using temporary tables
• How to populate temporary tables using INSERT and SELECT INTO
• Dynamic SQL with temporary tables: scoping issues

---

• Source: http://www.LearnTransactSQL.com
• Category: Server-Side Storage: Temp Tables, Table Variables, Cursors and More
• Skill Level: 300 (Intermediate)
• Length: 13:15 (7.03MB)
• Applies to Versions: SQL Server 2000
• 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 must have the TSCC codec installed to view this video

---

Keywords Associated with this video: best practices for temporary tables