T-SQL 101: #15 Using column and table aliases in SQL Server queries

added by DotNetKicks
5/13/2019 12:33:19 PM

1 Kicks, 204 Views

Look carefully at the following queries: I've shown several examples here of what are called aliases. There are two basic types of aliases. Column Alias In the first query, I've used a column alias. I wanted to query the Description column in the dbo.Products table but I wanted the column called ProductName instead.