SELECT a=1,b=2
vs
SELECT 1 AS a, 2 AS b
what approach should i use ? (by best practice decisions)
Is there any advantages of one vs the other ?
Asked
Active
Viewed 97 times
0
-
The differences are purely syntactic (which is another way of saying "there is no real difference"). – Sergey Kalinichenko Jan 25 '12 at 10:02
-
The second one is `ANSI` the first one isn't so if portability is a concern that might be relevant. – Martin Smith Jan 25 '12 at 10:07
-
@MartinSmith , thanks an important part indeed. but what benefit am i gaining from it being ANSI ? thanks :) – Royi Namir Jan 25 '12 at 10:11
-
Aaron Bertrand recently posted an article on the SQL Blog about this: https://sqlblog.org/2012/01/23/bad-habits-to-kick-using-as-instead-of-for-column-aliases – Tom Hunter Jan 27 '12 at 13:36
4 Answers
4
Personally I use AS - it is more explicit and used elsewhere (table aliases).
It is also standard - using the = syntax will not work on some databases.
I don't believe there are any performance implications for using one over the other.
Oded
- 489,969
- 99
- 883
- 1,009
2
I dont think where is a difference. But i would prefer the second approach. I think its more logical than the first.
So, i use the AS approach.
AS temporarily assigns a table column a new name. This grants the SQL developer the ability to make adjustments to the presentation of query results and allow the developer to label results more accurately without permanently renaming table columns. Source
dknaack
- 60,192
- 27
- 155
- 202
