To Toad for SQL Server community
shortcut key Alt-F1
shortcut key like Alt-F1 in SSMS to view table, views...detail information
SQL Editor : Browse Recent Ideas
Everything that can help you with editing your scripts. For instance, formatter, debugger or code completion
Moderators
-
I agree
0 votes
This idea is active.SQL Editor »Add your comment for Idea: shortcut key Alt-F1 -
I agree
2 votes
This idea is active.SQL Editor »Transpose / Pivot Results
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 »
1 comment for Idea: Transpose / Pivot ResultsWhen 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 »
-
I agree
8 votes
This idea is active.SQL Editor »Execution Plan should work with variables
3 comments for Idea: Execution Plan should work with variablesExecution Plan should work with variables.
Test SQL: select 'test' where '' = :par1
-
I agree
2 votes
This idea is active.SQL Editor »Table Description
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 »
Add your comment for Idea: Table DescriptionTo 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 »
-
I agree
3 votes
This idea is active.SQL Editor »Allow multiple rows in tab bar
3 comments for Idea: Allow multiple rows in tab barI 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.
-
I agree
3 votes
This idea is active.SQL Editor »Make the tab bar scrollable
Add your comment for Idea: Make the tab bar scrollableMake 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)
-
I agree
3 votes
This idea is active.SQL Editor »Configure Code Formatter By Example
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 »
1 comment for Idea: Configure Code Formatter By ExampleMake 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 »
-
I agree
4 votes
This idea is active.SQL Editor »Omit "Editor ...", "Viewer ..." from tabs
2 comments for Idea: Omit "Editor ...", "Viewer ..." from tabsNow 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.
-
I agree
6 votes
This idea is active.SQL Editor »Code completion in UPDATE..SET..FROM
3 comments for Idea: Code completion in UPDATE..SET..FROMToad 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
-
I agree
3 votes
This idea is active.SQL Editor »Enable Horizontal Scrolling with Tilt Wheel Mice
Add your comment for Idea: Enable Horizontal Scrolling with Tilt Wheel MiceEnable 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.
-
I agree
4 votes
This idea is active.SQL Editor »Support of syntax in the Code Completion
2 comments for Idea: Support of syntax in the Code CompletionHello!
I need support of syntax in the Code Completion.
It will help me in the code writing.
-
I agree
6 votes
This idea is active.SQL Editor »Fast code completion
1 comment for Idea: Fast code completionI wish my code completion come up with suggestion faster
Social Web