case sensitive column names

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

case sensitive column names

Postby NormL » Wed Aug 25, 2010 6:33 pm

Expanding the * on the following query gives:

SELECT
cc.Id ,
Sequence ,
cp.Id ,
sequence
FROM Central.Table1 cc
JOIN Central.Table2 cp ON cc.Id = cp.Id

Which returns:
Ambiguous column name 'Sequence'.
Ambiguous column name 'sequence'.

Would prefer it to generate this:

SELECT
cc.Id ,
cc.Sequence ,
cp.Id ,
cp.sequence
FROM Central.Table1 cc
JOIN Central.Table2 cp ON cc.Id = cp.Id
NormL
 
Posts: 5
Joined: Fri Apr 09, 2010 8:55 pm

Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 0 guests