Microsoft KB Archive/162032

= INF: Cannot SELECT DISTINCT * on a Table w/ Text/Image Column =

Article ID: 162032

Article Last Modified on 3/1/2005

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q162032



SUMMARY
SQL Server 6.5 no longer allows a 'SELECT DISTINCT * FROM ' if that table has a text/image column. If you attempting to perform such a query, you will receive the following error message:

Msg 8163: Text/Image datatype cannot be selected as DISTINCT.

Earlier versions of SQL Server treated this as a valid query if the table contained a unique index or primary key, whose existence would guarantee that the row was distinct. In the presence of such an index, the following message would have been raised:

Msg 421: TEXT and IMAGE datatypes may not be selected as DISTINCT.

SQL Server has never allowed a DISTINCT operation on an individual text

or image column.

Additional query words: sql60 sql65 error

Keywords: kbusage KB162032

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.