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