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?