More than two-part column name not supported after SQL2012

Posted: 2013-03-06 in Sql

Some interesting thing are exiting Ms SQL server (

The first one of note is:
Two part column name not supported
While mildly amusing that sql can be writting like this all Microsoft are really telling us is that this no longer supported:

select databasename.dbo.tablea.columnA
from databaseName.dbo.tableA

The work around (really really really lose term in this case here) is to simply alias the tables

select myAlias.columnA
from databaseName.dbo.tableA myAlias


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s