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 insert bullets in to cells in Microsoft Excel ?
Do you want to insert bullets in cells of Microsoft Excel?. Here's how you can do it. How to insert ...
How to resize print area and fit to Single page in Excel 2016 ?
When you try to print a worksheet in Microsoft Excel 2016 , you may notice that the content might ov...
How to find the Created and Last Modified time in Microsoft Excel ?
You can easily find out the exact date and time when the excel workbook was created and modified usi...