Tips that make life of a software engineer easier.
Well, not exactly. Some posts are open questions that I haven't found an answer ... yet
Monday, July 26, 2010
MS SQL Column Alias
T-SQL used in Microsoft SQL Server seem to have very limited support for column alias. If you have a complex calculated column that you want to re-use in GROUP, SELECT or another expression, it will be desirable to use alias to reference the same definition everywhere so that we can have a clear and easier to understand SQL statement.