Is there a best practice or any other compelling reason to use one of these techniques over the other?
The estimated execution plan looks identical for both so I'm not sure if there is any reason "As [LongName]" is any better or worse than "LongName ="
asked May 13 '10 at 02:32 PM in Default
The simple answer is that the AS clause is the ISO standard.
answered May 13 '10 at 02:53 PM
or any other compelling reason...
I tend to use brackets for column aliases and = for functions and expressions that tend to be longer such as:
rn = ROW_NUMBER() OVER.... where it is more readily apparent what rn represents instead of having to look at the end of the statement for: AS [rn].
answered May 13 '10 at 07:03 PM