How can we help you today? How can we help you today?

Using a previously assigned prefix

When I type:

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

I get:

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

Notice SQL Prompt used the same prefix for ORDERS and ORDERSDETAIL. Now if I was assigning the prefix myself I would use 'o' or ORDERS and 'od' for ORDERSDETAIL.

Query Analyzer
DaveTheWave
0

Comments

1 comment

Sort by
  • Lionel
    Thanks for the feeback. The generating of duplicate aliases is a bug and will be fixed by the finaly version. The reason it is not selecting a sensible alias for the ordersdetails table is that the table name is all uppercase. SQL Prompt takes the uppercase letters and uses the first one in each sequence to make the alias. So for example if you used OrderDetail as your table name you would get the alias od as expected. I realise you can't rename your tables just for SQL Prompt so I have added a sugestion to our list of features to let you specify the aliases for particular tables.

    Lionel
    Lionel
    0

Add comment

Please sign in to leave a comment.