More than two-part column name not supported after SQL2012

Posted: 2013-03-06 in Sql

Some interesting thing are exiting Ms SQL server (http://msdn.microsoft.com/en-us/library/ms143729.aspx)

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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s