Ispirer Website
Ispirer Capabilities - Microsoft SQL Server Migration
Free Trial
Three-part column references
Some statements required additional manipulations to be used in newer version of MSSQLServer 2008.
Microsoft SQL Server 2000:
SELECT <schema_name>.<table_name>.<column_name> FROM <schema_name>.<table_name>
Microsoft SQL Server 2008:
SELECT <alias_name>.<column_name> FROM <schema_name>.<table_name> <alias_name>
Example:
Microsoft SQL Server 2000:
SELECT dbo.tab1.col1 FROM dbo.tab1
Microsoft SQL Server 2008:
SELECT al.col1 FROM dbo.tab1 al