This video is from our "SQL Server 2000 Database Administration" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Video: Aliasing in Queries - What It Is and How to Use It (SQL Server 2000)

  • ·Skill level: 100 (Beginner)
  • ·Run Time: 5:02
  • ·Instructor: Scott Whigham

Description:

Table aliases, column aliases, column headers, resultset headers, range variables, correlation names - whew! That's a lot of terms to describe a simple concept! In this video, you'll learn the proper use of SQL aliases including when and where you can/cannot use them. Most queries can benefit from using aliases so understanding their use and Best Practices will certainly help you in your quest for SQL greatness.

Download and watch this video

NOTE: You will need the TSCC codec installed to view video

Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)

Chapter 7: T-SQL Basics: Queries, Datatypes, Collations and Unicode, and more
1 Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server
2 Defaults and Rules in SQL Server 2000 - What They Are, How to Use Them and Best Practices
3 Result sets, Recordsets, and the Client Server model
4 Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them
Aliasing in Queries - What It Is and How to Use It (SQL Server 2000)
6 Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work
7 Creating and Altering Views in the Enterprise Manager (SQL Server 2000)
8 Creating Linked Servers to Microsoft Access (SQL Server 2000)
9 Customizing SQL Server with International Error Messages and How SQL Server 2000 Uses the Default Language
10 Extended Properties in SQL Server 2000 - What They Are and How to Use Them to Generate Your Data Dictionary
11 How to Return Identity Value for a Just-Inserted Row
12 Interactive Help and Books Online - Using Context-Sensitive Help (SQL Server 2000)
13 Linked Servers - How to Query Microsoft Excel Named Ranges and Worksheets (SQL Server 2000)
14 Rapid Database Development Using Database Diagrams (SQL Server 2000)
15 Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000)
16 Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures Using the Create Stored Procedure Wizard
17 Views: Introduction, When and Where to Use, and Using the Create View Wizard
18 Working with User Defined Data Types in the Enterprise Manager (SQL Server 2000)
19 Pt. 1 - An Introduction to Using Views in SQL Server
20 Pt. 2 - Using Views in the Real World
21 Pt. 3 - Create View Syntax and Creating Views in SQL Server
22 Pt. 4 - Updateable Views in SQL Server (How to Update the Database Through a View)

NOTE: This video is part of our SQL Server 2000 Database Administration course.
This video is from Chapter 7: T-SQL Basics: Queries, Datatypes, Collations and Unicode, and more

Browse this course's videos now

© Copyright 2004-2009 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.