Force Column Alias with 'AS' keyword

[venkatesh2j]

Hello,

as we know we use use 'AS' keyword for column aliasing but even though if you wont use 'AS' keyword for column alias you can still be able to create alias
eg.1. select Column1 as Col1 from SomeTable
eg.1. select Column1 Col1 from SomeTable
Above both queries results with column alias as Col1

But while writing huge stored procedure, if we miss a comma(,) between two columns then latter column name becomes alias for other column.
eg. Select column1,
Column2,
Column3
Column4
So this will result in 3 columns Column1,Column2 and Column4. Since Column3 has no comma Column4 acts as alias. How can we avoid this (Please dont tell me to be more carefull) is there are references is available to force alias to presented with AS keyword or any other method is present

[Rabbit]

I don't know of a setting off the top of my head that requires the SQL interpreter to require using AS when defining an alias.

[NeoPa]

venkatesh2j:
(Please dont tell me to be more carefull)

Ultimately that's all you can do. You could possibly write a macro that checks your SQL, but that wouldn't be too straightforward. Parsing SQL is a complicated job with many syntax rules to reproduce.

As Rabbit says, I'm pretty sure there is no option within SQL to disable this particular item within SQL syntax. After all, there are published standards on SQL and that syntax is part of those standards.

[venkatesh2j]

thanks chaps!! gave a try might some people has any work around..

[NeoPa]

Suck it and see.

If it does what you expect then it's not likely to have any extraneous ALIASes.