Should alias names be preceded by AS? - Part 2

Published 09 September 08 12:10 PM | Madhivanan 

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?

Filed under: , ,

Comments

# Other SQL Server Blogs around the Web said on September 9, 2008 7:47 AM:

In the Part 1 , I expressed my opinion on having the alias names preceded by the keyword AS Adding to

# SQL Server Transact-SQL (SSQA.net) : Should alias names be preceded by AS? - Part 2 said on September 9, 2008 11:24 AM:

PingBack from http://sqlserver-qa.net/blogs/t-sql/archive/2008/09/09/4861.aspx

# Log Buffer #114: A Carnival of the Vanities for DBAs said on September 12, 2008 11:16 AM:

PingBack from http://www.pythian.com/blogs/1218/log-buffer-114-a-carnival-of-the-vanities-for-dbas

Anonymous comments are disabled

Search

Go

This Blog

«September 2008»
SMTWTFS
31123456
78910111213
14151617181920
21222324252627
2829301234
567891011

Syndication