SQL Server: Tips and Tricks - 2 (2017)
Understand Column Alias in Select Query in SQL Server
You are working as SQL Server developer, you need to extract the data from dbo.Customer table and provide in an Excel Sheet. Your table has difference columns such as FName, LName but you want the output to come with FirstName and LastName. How would you do that?
Alias is a great way to make your column names more readable. As in our question above, we want to display FName as FirstName and LName as LastName, Alias is the way to go. Let's create dbo.Customer table with columns and then use select query with alias to display Columns as we like.
Create table dbo.Customer
insert into dbo.Customer
To create Alias you can use "AS" after column name or simply provide the alias right after column name. In below query, I have use "as" for FName but did not use for LName.
Select FName as FirstName,
If you would like to have space between your Alias Column Name such as "First Name". You can use [ ] around the alias or double quotes e.g "First Name".
Select FName as [First Name],
LName as "Last Name"