Comments on SELECT "AliasName" = ColName vs. AS

Question

Comments on SELECT "AliasName" = ColName vs. AS

mbarrentine

SSC Enthusiast

Points: 112
More actions
January 3, 2004 at 8:17 pm

#152001

Your thoughts on using SELECT "AliasName" = ColName vs. SELECT ColName AS "AliasName". ColName could also be calculated data (either string concatenation or numeric).
I find having a mixture of alias names and table column names all on the left side is easier to follow than to have the table column names on the left and column aliases on the right.
SELECT
OrderID,
ProductID,
"Amount" = UnitPrice * Quantity,
"Long Case" = CASE
WHEN .....
WHEN .....
ELSE ...
END
versus the harder to follow (at least for me)
SELECT
OrderID,
ProductID,
UnitPrice * Quantity AS "Amount",
CASE
WHEN .....
WHEN .....
ELSE ...
END AS "Long Case"
From the research I have done thus far, "AS" is ANSI complient whereas "=" is not. Microsoft's "Best Practices Analyzer" didn't complain about the "=" as long as I enclosed the alias name in quotes.
So as long as the code is written strictly for SQL Server, the "=" should be OK unless MS decides to remove this from future versions?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

jxflagg Hall of Fame Points: 3817 More actions · Answer 1

This sounds like it may be a religious issue. I guess it all depends on what you're used to. I've always used ColName as AliasName and I've found it to be very readable. I tend to line up my aliases in a column so I can immedidately recognize which columns are aliased.

I would think you're fine as long as you're consistent.

Crispin Proctor SSCoach Points: 18161 More actions · Answer 2

Note in all the system procs, MS use 'aaa' = and not AS.

I personally use AS the same way jxflagg does. Makes it easy to read.

Reason why Microsoft's "Best Practices Analyzer" didn't complain. They do it

Cheers,

Crispin

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Actually I only want to ask if you can be really sure to always develop against SQL Server? Although which style you choose depends on personal preferences, but I would stick to the ANSI Standard. I guess that's what standards are for

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 4

Functionality should be the same. Physical implementation might not be. I'd stick to aht ANSI standard. cfr isnull and coalesce.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

edwin_fredrick Old Hand Points: 364 More actions · Answer 5

ANSI is the way to go. but if you stick to ANSI standards you wont be able to use functions. Some of the additional features provided my MS SQL are not ANSI standard.

I am not sure if ANSI supports functions