Posted on: 11/18/2013 8:58:03 PM | Views : 788

Well, not exactly.
Which of the following is the standard? Interested in knowing which one is 'best practice' and which one is 'worst practice'. By the way all compile and return correct result. The Server is SQL Server 2012 Express with Northwind as the database context.
Select LastName LN from dbo.Employees
 
Select LastName as [Last Name] from dbo.Employees
 
Select Lastname as 'Last Name' from dbo.employees
 
Select LastName "Last Name of employee" from Employees --not compliant SQL92
 
Select LastName as "Last Name" from Employees
 
Select LastName="LastName" from Employees
 
SELECT LastName "LastName" fr ...

Go to the complete details ...