Other ways of specifying the alias name for a column in SQL Server

When we work on SQL Server query , we use the AS keyword to specify the alias name for a column.

For example ,

SELECT Name AS "First Name" FROM Employee

In the above query , the Name column has a alias name “First Name”. In this case , we used the “AS” keyword to specify the alias name.

Infact SQL Server also provides other options to specify the alias name . These include

– Specifying the alias name without the AS clause.

Below are the usage of the same.

SELECT Name "First Name" FROM Employee

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


Interesting BlogPosts to read

How to quickly remove multiple line breaks in Excel using VBA code?
There are times when you might copy few data from different source and you would end up getting unne...
How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...
How to hide page breaks in worksheets in Microsoft Excel ?
When the page breaks is used to adjust the print area in a worksheet in excel , this would show up a...