Activity overview
Latest activity by MichaelG
You're correct,
- That helps
But in my opion even if you hav the other options on the list should be sorted so that the FK:s comes prior to the other guesses, which are weaker and may misslead a user to use a incorrect join option before the design FK join option.
- So, please but on your feature wishlist
thanks alot
Michael / comments
You're correct,
- That helps
But in my opion even if you hav the other options on the list should be sorted so that the FK:s comes prior to the other guesses, which are weaker and may misslead a us...
Hi Bart,
Thanks for a quick reply.
Yes, that's exactly what I mean.
I checked the option you suggested, but it maid no difference...
I made an Example using Microsoft AdventureWorks database:
USE [AdventureWorks]
GO
SELECT *
FROM Product prod
INNER JOIN [ProductSubcategory] sCat
ON
-- My list from SQL Prompt (after writing ON (space) above)
/*
prod.[Name] = sCat.[Name]
prod.[DaysToManufacture] = sCat.[ProductCategoryID]
prod.[DaysToManufacture] = sCat.[ProductSubcategoryID]
prod.[DiscontinuedDate] = sCat.[ModifiedDate]
prod.[FinishedGoodsFlag] = sCat.[Name]
prod.[MakeFlag] = sCat.[Name]
prod.[ModifiedDate] = sCat.[ModifiedDate]
prod.[ProductID] = sCat.[ProductCategoryID]
prod.[ProductID] = sCat.[ProductSubcategoryID]
prod.[ProductModelID] = sCat.[ProductCategoryID]
prod.[ProductModelID] = sCat.[ProductSubcategoryID]
prod.[ProductSubcategoryID] = sCat.[ProductCategoryID]
prod.[ProductSubcategoryID] = sCat.[ProductSubcategoryID] -- this is the constraint join I want first(ish) (13th place (scroll starts at 11)
-- ...
*/
-- I also tried revering the order of the join (subcategory first)
SELECT *
FROM [ProductSubcategory] scat
INNER JOIN Product [Product]
ON scat.[ProductSubcategoryID] = Product.[ProductSubcategoryID] -- 12th place in list / comments
Hi Bart,
Thanks for a quick reply.
Yes, that's exactly what I mean.
I checked the option you suggested, but it maid no difference...
I made an Example using Microsoft AdventureWorks database:
USE [...
Making the selection list ordering smarter
Hi,
A small (but to me significant) feature request
In the current version the ordering when getting the sql prompt selection list. I think the ordering could be improved.
Specifically in the ON se...