SQL Server Performance

Should alias names be preceded by AS? - Part 2

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Sep 9, 2008.

  1. Anonymous New Member

    In the Part 1 , I expressed my opinion on having the alias names preceded by the keyword AS Adding to the examples given at the link, consider this example too SELECT 10number , 10.number , 10 number , 10 [number] , 10[number] , 10 as number It gives six columns with the result 10 and alias name number. Note that the first two expressions seem to be completely misleading Am I right in insisting that SQL Server should force the usage of AS before the alias name?...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2008/09/09/4861.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=4861" width="1" height="1">

Share This Page