New Transact SQL Video Tutorial: UNION Queries - What They Are and How to Use Them (SQL Server 2000)

UNION Queries - What They Are and How to Use Them (SQL Server 2000) - view details

Although less popular than JOINs, UNIONs are another way to work with multiple tables in the same query. Much of the time UNIONs are used to generate lists of things; i.e., "Find all Customers and Suppliers in the United States". This video gives you the basic syntax and, more importantly, the logic behind how it works and when to use UNION vs. UNION ALL.

Note: This video was shot on SQL Server 2000's Query Analyzer but the same logic applies for SQL Server 2005

Highlights from this video:

• Difference between UNION and UNION ALL
• Performance with UNION
• Including indicators in result sets to identify which table a row comes from
• Writing UNION compatible queries
• Datatype mismatches in UNIONs and how to avoid them
• ORDER BY in UNION queries

• Category: JOINs and UNIONs - Working with Multiple Tables
• Skill Level: 200 (Beginner - Intermediate)
• Length: 7:43 (4.6MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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