Table Names in 2 Part Naming Convention in Select List

Question

Post reply

Table Names in 2 Part Naming Convention in Select List

Jeff Moden

SSC Guru

Points: 1004617
More actions
January 26, 2012 at 10:16 pm

#254417

Gosh... I must be losing my marbles. I'm trying to prove to my new boss that the use of table names in 2 part naming in the SELECT list has been deprecated. I was sure that I saw it in the deprecation list for 2008 (non-R2) about a year (maybe more) ago. No, after goiing over the deprecation list again and again, I find no such thing and I'm really sure it used to be there.
Does anyone else remember this particular deprecation?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Paul White SSC Guru Points: 150468 More actions · Answer 1

These are the only two I can find (2008-2012):

SELECT *

FROM sys.dm_os_performance_counters AS dopc

WHERE dopc.object_name LIKE N'%:Deprecated Features%'

AND dopc.instance_name LIKE N'%part%';

Perhaps you were thinking of the 'more than two-part name' one? For example, this query increments the counter:

SELECT Production.Product.ProductID

FROM Production.Product;

SQL Server, Deprecated Features Object

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Jeff Moden SSC Guru Points: 1004617 More actions Follow · Answer 2

Thanks, Paul...

The deprecation that I remember was based on using table names instead of alias names for column callout in the SELECT list. Like this...

SELECT TableName.SomeColumnName

FROM dbo.TableName

The recommendation was to use a table alias instead of the table name in the select list (of course, you'd need to add the alias in the FROM clause, as well).

I know about the deprecation on 3 and 4 part naming conventions and haven't gotten those confused here.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Paul White SSC Guru Points: 150468 More actions · Answer 3

Jeff Moden (1/26/2012)
The deprecation that I remember was based on using table names instead of alias names for column callout in the SELECT list. Like this...
SELECT TableName.SomeColumnName
FROM dbo.TableName
The recommendation was to use a table alias instead of the table name in the select list (of course, you'd need to add the alias in the FROM clause, as well).

Hm, well as far as I know, that syntax is in the SQL standard, so unlikely to be deprecated in SQL Server.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Jeff Moden SSC Guru Points: 1004617 More actions Follow · Answer 4

SQL Kiwi (1/26/2012)
Jeff Moden (1/26/2012)
The deprecation that I remember was based on using table names instead of alias names for column callout in the SELECT list. Like this...
SELECT TableName.SomeColumnName
FROM dbo.TableName
The recommendation was to use a table alias instead of the table name in the select list (of course, you'd need to add the alias in the FROM clause, as well).
Hm, well as far as I know, that syntax is in the SQL standard, so unlikely to be deprecated in SQL Server.

Agreed... that's why I'm thinking it's no longer on the deprecation list but I really do remember seeing it there about a year ago. I'm just trying to find someone besides me who remembers seeing it.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Paul White SSC Guru Points: 150468 More actions · Answer 5

Jeff Moden (1/26/2012)
Agreed... that's why I'm thinking it's no longer on the deprecation list but I really do remember seeing it there about a year ago. I'm just trying to find someone besides me who remembers seeing it.

I would ask the question on the MVP DL; I expect UC would be able to offer a definitive answer.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Jeff Moden SSC Guru Points: 1004617 More actions Follow · Answer 6

Good idea, Paul. Thanks.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Table Names in 2 Part Naming Convention in Select List

Cookies on SQLServerCentral