Member since 1 year ago
4 ideas posted
4 comments 9 votes
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 »
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.
2 votes
Auto-replace:Add an option to the SQL Versions Pick list for "SQL Server (Any Version)". Currently, if you want to have a custom auto-replace keyword work in any version of SQL, you have to manually populate that keyword for every version by selecting the version, then populating it. I'd like to see an "Any version" option added to the list that would always be checked regardless of the version of SQL (In addition ...more »
Auto-replace:Add an option to the SQL Versions Pick list for "SQL Server (Any Version)".
Currently, if you want to have a custom auto-replace keyword work in any version of SQL, you have to manually populate that keyword for every version by selecting the version, then populating it. I'd like to see an "Any version" option added to the list that would always be checked regardless of the version of SQL (In addition to the version-specific ones).
I use this feature for example to automatically capitalize keywords like SELECT FROM INSERT INTO IN WHERE HAVING, etc as I type them.
« less full details »
To Toad for SQL Server community
Social Web