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 09 September 2008 14:19 by Madhivanan
Filed under: , ,

Comments

# Fishy feature? | keyongtech

28 May 2009 13:08 by Fishy feature? | keyongtech

Pingback from  Fishy feature? | keyongtech