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.
Pin It

Leave a Reply

Your email address will not be published. Required fields are marked *