Everything that can help you with editing your scripts. For instance, formatter, debugger or code completion
2 votes
When you right-click an object, and choose Generate SQL after making your selection of what to generate (ALTER Script for example), the current list of options is:
- To Editor
- To Clipboard
- To File
I'd like to see a 4th option:
- To Editor at Cursor Location
99% of the time when I'm choosing the to clipboard option i end up just pasting the script where my cursor happens to be located anyway.
2 votes
When working with tables that contain hundreds of columns but few rows, it is better to look at the data transposed with each column name as a row and with each row as a column. Basically, the equivalent of exporting the data to Excel, selecting it, and choosing paste, transpose. The card view in Toad was an attempt at doing that, but it fails miserably because: 1. It repeats the column names on every "card" -- ...more »
When working with tables that contain hundreds of columns but few rows, it is better to look at the data transposed with each column name as a row and with each row as a column.
Basically, the equivalent of exporting the data to Excel, selecting it, and choosing paste, transpose.
The card view in Toad was an attempt at doing that, but it fails miserably because:
1. It repeats the column names on every "card" -- wasting valuable screen real-estate.
2. It does not contain a vertical scroll bar, so if there are hundreds of columns, there's no practical way to get to them.
Desired: a new option on in the Results Window: Right-Click: Show: menu that reads: "Transposed View".
When selected, users would see data with the column names in the first column (frozen in place). Scrolling vertically displays the other columns, scrolling horizontally displays the other rows but keeps the column names visible.
« less full details »
2 votes
Make the Group Execute feature available on ALL editor tabs by default. This is a royal pain as I have to enable it per editor window.
8 votes
Execution Plan should work with variables.
Test SQL: select 'test' where '' = :par1
2 votes
To all: I recently was asked to come up with a simple script to describe a table/view column and is most useful ddl attributes. The below uses the INFORMATION_SCHEMA.COLUMNS which I happen to like for this purpose. It is very fast and very useful, I have submitted this to the Toad-SS idea pond so as to share the code. TDA and SQL Server user should give it a try. select table_name, Table_Schema,column_name, Ordinal_Position ...more »
To all:
I recently was asked to come up with a simple script to describe a table/view column and is most useful ddl attributes. The below uses the INFORMATION_SCHEMA.COLUMNS which I happen to like for this purpose.
It is very fast and very useful, I have submitted this to the Toad-SS idea pond so as to share the code. TDA and SQL Server user should give it a try.
select table_name, Table_Schema,column_name, Ordinal_Position
,DATA_TYPE
, isnull(cast(character_maximum_length as varchar(15)) ,'NA') as 'Char_Length' --- So as not to return nulls values.
, isnull(cast(NUMERIC_PRECISION as varchar(15)) ,'NA') as 'NUMERIC_PRECISION' --- So as not to return nulls values.
, isnull(cast(NUMERIC_SCALE as varchar(15)) ,'NA') as 'NUMERIC_SCALE' --- So as not to return nulls values.
, IS_NULLABLE
, isnull(cast(Column_Default as varchar(15)) ,'NA') as 'Column_Default'
from INFORMATION_SCHEMA.COLUMNS a
where table_name = 'MeterInventory' -- order by 3
« less full details »
3 votes
I usually have many editors open at the same time. To avoid scrolling right/left each time I want to change the tab, I suggest that you provide an option to allow multiple rows for the horizontal tab bar. Of course I can always use the window list, but then I need two clicks each time I change to another tab.
3 votes
Make the tab bar scrollable. Scrolling up/down using the mouse wheel on the tab bar should shift the tabs left/right. (this can replace the two arrows on the right hand side)
3 votes
Make it easier to configure the code formatter. Some ideas: 1. Make the code example in the preview pane a COMPREHENSIVE example (i.e. the minimum number of cases of different SQL constructs that would illustrate the current formatting configuration.) 2. Possibly make this a separate dialog or screen so that one could see the effects in the preview pane in realtime as one changes the custom configuration. 3. Consider ...more »
Make it easier to configure the code formatter.
Some ideas:
1. Make the code example in the preview pane a COMPREHENSIVE example (i.e. the minimum number of cases of different SQL constructs that would illustrate the current formatting configuration.)
2. Possibly make this a separate dialog or screen so that one could see the effects in the preview pane in realtime as one changes the custom configuration.
3. Consider building a "Format Analyzer" that reads a template file. You'd supply the user this template file containing a set of SQL constructs and different cases that the user needs to consider. The user would manually format a copy of the template using whatever editor they like (TOAD, or something else) and make it look like they want it. Then feed it to the Format Analyzer which does its best to produce a configuration that would produce that formatting.
When the analysis is done, it should produce a report of the settings it chose, and why, and a machine-formatted output of the configuration template so the user can compare their input with it.
== Obviously there are a lot of ways this feature could "go wrong," but don't dismiss the idea yet! ==
If the user deletes stuff, or moves it around, or adds extraneous things to the template so the analyzer has trouble working, scold the user for doing that (!!) :-) and tell them to try again from a clean copy of the template. (Ease of use doesn't come for free and no SQL developer in their right mind should expect the program to exhibit human understanding!)
The analyzer may find 2 different values for a setting, neither of which exactly reproduce the user's formatting, but both of which are pretty close. Choose 1 arbitrarily and, when done, create a report window (or some kind of output) listing these pairs of choices, including what the setting is, what the 2 choices were, and what the unchosen alternative would have produced.
It is conceivable the analyzer might be forced into a mutually-exclusive pair of choices if the user's formatting is creative enough. (Maybe they right-aligned keywords everywhere except in one or two places, for example?) Again, do the same treatment as above: choose 1 arbitrarily and report on the either/or choice and why the user's example forced this.
« less full details »
4 votes
Now in 5.7 beta, tabs have icons on them. Editors have a notepad icon, viewers have a magnifier icon and so on. I suggest that you omit the words "Editor ..." or "Viewer ..." from the tabs to save screen real estate. The user can already tell if the tab is an editor or a viewer by looking at the icon. However for the tabs that are less frequently used (e.g. Data diff viewer) you should keep the name.
6 votes
Toad should support code completion in UPDATE..SET..FROM
For example, code completion for:
UPDATE x
SET foo=123
FROM Bar x
should work the same as for:
UPDATE Bar
SET foo=123
Toad should support code completion for joins in FROM statement:
UPDATE x
SET foo=123
FROM Bar x JOIN Bar2 y ON x.id=y.xid
WHERE y.foo2 = 234
3 votes
Enable Horizontal Scrolling with Tilt Wheel Mice that include this feature.
For some reason the horizontal scrolling features of Microsoft Intellipoint tilt wheel mice do not seem to work in the Toad Editor Window. Add support for that.
4 votes
Hello!
I need support of syntax in the Code Completion.
It will help me in the code writing.
6 votes
I wish my code completion come up with suggestion faster
To Toad for SQL Server community
Social Web