Ispirer Website
Ispirer Capabilities - Microsoft SQL Server Migration
Free Trial
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>
Example:
Microsoft SQL Server 2000:
SELECT good_date, CONVERT(VARCHAR, good_date,112) AS good_date FROM shop ORDER BY good_date
Microsoft SQL Server 2008:
SELECT good_date, CONVERT(VARCHAR, good_date,112) AS good_date FROM shop ORDER BY shop.good_date