Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

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 

Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

sqlways/sql-server/upgrade/statementssyntax/threepartcolumn.txt · Last modified: May 07, 2018, 03:15:34 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement