Should alias names be preceded by AS? - Part 2

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?

Published Tuesday, September 9, 2008 2:19 PM by Madhivanan
Filed under: , ,

Comments

# Fishy feature? | keyongtech

Thursday, May 28, 2009 1:08 PM by Fishy feature? | keyongtech

Pingback from  Fishy feature? | keyongtech