Posts
Sort by recent activity
Can not find a column from the where clause
When I type:
select od.[ORDERID], od.[FINALPRODUCTID], od.[HEEL], o.[orderCategory], od.[CustomerOrderDetailId]
from [dbo].[ORDERSDETAIL] od
join [dbo].[ORDERS] AS o
where F
I expect to be able to ...
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]....
CTRL+SPACE after JOIN gives me column names
If I invoke the completion canidate list immediately after the JOIN keyword, I am presented with the "All common objects" list. I would rather be presented with the "Tables" list.
Query Analyzer
Prefix is duplicating
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 pre...
Column spacing on completion canidate list
If I expand the completion canidate list, all columns expand by the same amount.
I think it would be nice to set the column widths individually. Or have a max width based on the longest table/colum...
SQL Prompt creates a prefix
I was trying to type this:
select [ORDERID]
from [dbo].[ORDERSDETAIL]
and got this instead:
select o.[ORDERID]
from [dbo].[ORDERSDETAIL]
SQL Prompt created a prefix for the select elements but did ...