Ispirer Migration Knowledge Base

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:

SELECT CONVERT(VARCHAR, good_date,112) AS good_date, good_date  FROM shop
ORDER BY shop.good_date

Microsoft SQL Server 2008:

SELECT CONVERT(VARCHAR, good_date,112)  AS good_date, good_date FROM shop
ORDER BY CONVERT(VARCHAR, good_date,112)