Hello community: I’m running both 18.104.22.1684 for SqlServer and 22.214.171.1245 for MySql as I have both Db’s inhouse, and therefore Toad is a dream come true.
My question is simple: although the interfaces look the same, there are some functional differences that are really a pain: My main two problems are:
I often have multiple verions of a query in the editor window, each ending with a “;” .in MySQL verson, just positioning the cursor anywhere inside a query and hitting F9 will run that query, whereas in SQLServer you have to highlight the whole query and then hit f9.
In MySQL double-clicking a table in the explorer automatically adds a new window for it, whereas in the SQLServer Version, you have to “right-click”, add new window…
Am I totally stupid and is there a simple way to make both behave the same (i.e. like the MySQL version) ???
Hi, will try to assist you with your questions:
- To execute whole script use F5 hotkey. See left button on Editor toolbar.
- You can set up such things in Toad Options: Tools->Options->Explorer->General: Double-click option. Set ‘Open details’ instead of ‘Invoke default action’
Hope it will help.
Small comment on #1.
I suggest fracesco_062 wants to place cursor anywhere inside the statement and
then execute this statement just pressing F9 without previously selecting
anything – just how he does in Toad for MySql.
Yes, there is a difference in Toad behavior for those platforms because in T-SQL
statement designator ( is not required. You can use it or you can omit it.
That is why F5 in Toad for SQL Server executes the whole batch which is part of
the script up to the next GO, or the whole script if there is no any GO. You can
imitate MySql behavior by placing GO after each statement.
Thank you both for your very kind and prompt replies.
Yes Igor, you got the point exactly: so just one last thing before I close the question and then get lost ;-~
Basically, what you’re saying (and I’ve tried, is by just putting GO instead of “;” I get the effect I want! So why don’t they put an interpreter that takes the “;” and interprets it as GO ??
GO is batch separator, not statement terminator and behaves similar to ( only
in this particular case – when batch contains exactly one SQL statement. I
would prefer “they” J make using ( obligatory instead.