Activity overview
Latest activity by JoDouglass
Likewise, I'd be interested to know if there's evidence this is likely to be deprecated in future, or where MS are saying we should avoid using it. I've not seen anything suggesting either, and the list of deprecated features even suggests it as a suitable alternative to the deprecated 'string_alias' = <expression> syntax.
It would be a real shame if it happened as it's so much more readable having the aliases first in an aligned list rather than having to find them at the end of the columns. I'm a late convert to this style, having moved over from Oracle, and then used the standard syntax the first couple of years I was on SQL Server. Despite years of using the AS syntax I find this much easier to read and a big time saver.
I've never given the portability issue much weight - in the highly unlikely event I had to move all my SQL to a different platform, changing alias styles would be the least of my worries! And I could switch them all using SQLPrompt before migrating. [image]
Obviously if it were deprecated I'd have to switch at some point regardless of it being beneficial, so it would be good to know if I've missed something. / comments
Likewise, I'd be interested to know if there's evidence this is likely to be deprecated in future, or where MS are saying we should avoid using it. I've not seen anything suggesting either, and the...
Any news on this fix?
Under Style rules, I think ST002 (Old-style column alias via EQUAL sign) is wrong for the same reason. The help claims that this style of alias is deprecated - it isn't, and afaik there is no reason to flag this style up as problematic.
The only argument I'm aware of for not using it is that it's SQL Server specific. If the rule is going to remain, could the help files perhaps be updated to reflect this?
I know it's a less popular style, but I greatly prefer it for readability reasons - and I'm in good company. [image] http://sqlblog.com/blogs/aaron_bertrand/archive/2012/01/23/bad-habits-to-kick-using-as-instead-of-for-column-aliases.aspx / comments
Any news on this fix?
Under Style rules, I think ST002 (Old-style column alias via EQUAL sign) is wrong for the same reason. The help claims that this style of alias is deprecated - it isn't, and a...
Excellent, thanks for the updates! / comments
Excellent, thanks for the updates!
New formatting styles - alignment after 'where exists' incorrect
First off, thanks for the new formatting styles - they're excellent, and I'm now able to get very close to how I prefer to write SQL. However, I have noticed an issue.
I use the "right aligned to s...