We are migrating from SQL Server 2000 to SQL Server 2008 R2 and our web application having thousands of SQL Statement with "Column Alias in ORDER BY Clause ".It is very difficulty to change all
One of article says that SQL Server 2005/SQL Server 2008 not support
"Column Alias in ORDER BY Clause and we have to replace with column name" because of this issue If we change Alias name to column name, we have do enter application/integrity testing.
it is going to be big deal.
our client Decided to stop migration, Please some help is there any other alternative.
View Complete Post