Ispirer Migration Knowledge Base sqlways:sql-server:upgrade:statementssyntax:orderby-alias https://wiki.ispirer.com/ 2026-04-08T08:56:23+00:00 Ispirer Migration Knowledge Base https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) Function after Column https://wiki.ispirer.com/sqlways/sql-server/upgrade/statementssyntax/orderby-alias/function-after?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Function after Column Microsoft SQL Server 2000: select <column1> ,<function> as <column1> from <table_name1> order by <column1> Microsoft SQL Server 2008: select <column1> ,<function> as <column1> from <table_name1> order by < table_name1.column1> text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) Function before Column https://wiki.ispirer.com/sqlways/sql-server/upgrade/statementssyntax/orderby-alias/function-before?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Function before Column Microsoft SQL Server 2000: select <function> as <column1>,<column1> from <table_name1> order by <column1> Microsoft SQL Server 2008: select <function> as <column1>,<column1> from <table_name1> order by <function> Microsoft SQL Server 2000: text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) DISTINCT and ORDER BY https://wiki.ispirer.com/sqlways/sql-server/upgrade/statementssyntax/orderby-alias/orderby-distinct?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing DISTINCT and ORDER BY Microsoft SQL Server 2000: select distinct <function> as <column1> from <table_name1> order by <table_name1>.<column1> Microsoft SQL Server 2008: select distinct <function> as <column1> from <table_name1> order by <column1>