Flaws in Query Builder

Toad for SQL Server
1

Hello,

I am new to Toad. While checking the Query Builder (QB) I noticed that QB does not support important hints like "WITH (NOLOCK)" and different sort orders of two different databases like "COLLATE SQL_Latin1_General_CP1_CI_AS", while MSSMS does not cause any problems here and processes such statements properly.

My question: Since these features are important, when can Toad do this?

Greetings

Stephen

2

Toad supports both hint directives and different collation/sort orders.
Screen snap shows a Query Builder in the background where I added the NOLOCK hint to the created query, and foreground panel is courtesy of the Server Properties.

You might need to give us details of how/where you're trying to introduce these concepts within the product?

image
image1543×873 135 KB

3

Hi Gary,

if you now try to Visualize Query as suggestet in green, the following Message appears

image
image1022×439 17.5 KB

Greetings

Stephan

4

OK, I see. Yes, this can/does happen frequently. Reason is that it's more difficult to render a diagram from query text than it is to produce the SQL from the Query Diagram. That, along with the fact that the Query Builder interface does not have the means (yet?) to account for some things like optimization directives, etc.

When you press OK on this message panel, you should still be able to run your query, and the diagram will be rendered as best as TDP knows how to do, although it may not reflect some of your changes. I know the Dev team is working on improving the process of Visualization... stay tuned for future releases!

5

Hello Gary,

I just stumbled across an old post from 2014.

https://forums.toadworld.com/t/querybuilder-and-with-nolock-hint/29147

That means that for 7 years you have not been able to eliminate this circumstance?
My tendency is to not renew my subscription after it expires.

Further, I have a subscription to Toad for SQL Server. However, I get emailed in your Summary topics for primarily Oracle, which does not interest me at all. It can't be that difficult to inform the customer only about new topics for which he also has a subscription.

Very disappointed

Stephan