If I type:

select o.[ORDERID], o.[FINALPRODUCTID], o.HEEL
from [dbo].[ORDERSDETAIL] o

I get:

select o.[ORDERID], o.[FINALPRODUCTID], o.o.[HEEL]
from [dbo].[ORDERSDETAIL] o

Notice the duplicated prefix.

This is from Query Analyzer.
DaveTheWave
0

Comments

2 comments

  • DaveTheWave
    I've noticed that SQL Prompt completly ignores the fact that I've already specified a table by typing 'o.' and then invoking canidate completion.
    DaveTheWave
    0
  • Lionel
    Thanks for the feedback. I have entered it into our bug tracking system. This will definatly get fixed in the final version as is most anoying.

    Lionel
    Lionel
    0

Add comment

Please sign in to leave a comment.