663 results found
-
One feature idea that I think would be great for many customers. Often I have a pasted column of data from Excel that i need to run a macro
One feature idea that I think would be great for many customers. Often I have a pasted column of data from Excel that i need to run a macro on in Notepad++ to add single quotes and commas. So that I can paste the string into a SQL “in ( ) " clause.
It would be amazing if SQL Prompt had an option to convert that clipboard text right in SSMS. I think lots of people would find that a timesaver.
1 vote -
Make Import / Export of options more flexible (xml file format or enable partial export of sections)
I would like to be able to export (+import) only specific portions of the options.
So that I - for instance - may only distribute my aliases or my coding style options to the team; not everything. The current binary format for the export file only allows for an all-or-nothing approach.
So please
(A) Make the export file a xml-format, so we can filter it ourselves
or
(B) Add a dialog to allow us to mark the sections to be included into the export file via checkboxesThis would also likely solve other feature-requests:
- https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/46784125-export-snippets-to-text-file
- https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/40966285-sql-prompt-setting-sharing
- https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/39174019-import-and-export-aliases1 vote -
Format SQL & Entity Framework — making EF SQL easily readable
I have the misfortune of trying to read an EF query. It would be extremely helpful if the «Format SQL» function in SQL Prompt could greatly reduce the verbosity and make the massively nested queries much, much easier to read.
This is what I am doing by hand:
• Replacing names like 'Extent6' with letters of the alphabet. I will go back later and replace these letters with more helpful names. Because the aliases of the table-valued objects are so long, so is there so much more text to plough through;
• Removing aliases from columns whose names are identical.…
1 vote -
Aliases for synonyms
When using a synonym, the alias name generated is based on the synonym orginal table, not in the synonym name.
So, if I have a synonym named sch1.ShortTableName that maps on AnotherDatabase.sch2.TableWithLongAndComplexName
If I write
SELECT * FROM sch1.ShortTableName
It ends being
SELECT * FROM sch1.ShortTableName AS twlacn
It would be good that in case of synonyms, the alias name was based on the synonym name, not on the source object name.
Or to keep backwards compatibilty, to have a setting that lets us choos either to follow the synonym name or the source object name.
2 votes -
Close pop up windows when holding down the control key while editing sql in SSMS
While editing code in SSMS, i often find I want to use control key navigation (ctrl - left arrow for example) to navigate to a different part of the text i'm editing, but a pop-up intellisense window has arrived and instead of moving to the start of the word i'm editing, its trying to make me choose things from its pop up. It would be nice if ctrl key navigation would auto close the intellisense window so I could continue moving around the text of my query instead of having to hit escape all the time to close the pop…
1 vote -
Allign all euals of a set part in an updatestatement
Allign all equals of a set part in an update statement
2 votes -
When setting tab colors, allow/disallow the status bar to mirror the tab color
I am color-blind and while tab coloring isn't as big an issue, the real estate of the status bar and font size makes certain color schemes that I use on tabs VERY difficult to read. I would love an option to select whether the tab color propagates to the status bar and possibly even separately set a different "default" color for the status bar. I know some have requested the status bar mirror the tab color but some of us color-challenged developers would rather not have that option. Note, the "default" color could be consistent across all environments rather than…
1 vote -
Fix SQL History
User of SQL Prompt for some years now. Tab History was a "killer feature". I often have multiple instances of SSMS open, with a number of ad-hoc queries open not worth saving. When I log back in, for years, WITHOUT FAIL, ALL my queries, from ALL instances would re-open.
Since "upgrading" to SQL; History, I am lucky to get one or two re-open. Complete pot luck. Even searching for known keywords to get them open again is hit and miss.
I am losing a lot of productivity due to this downgrade. I have yet to experience any benefit from the…
15 votes -
Bring Back Tab History
Tab History NEVER should have been replaced with SQL History, a very poorly received roll-out that angered many paying customers. The fact that Red-gate felt it necessary to re-brand the thing is indication enough that it wasn't simply an update to Tab history but a replacement. That said when you do something like this in a product people are paying for it should be rolled out as something new and not something that replaces an existing beloved feature.
Perhaps after enough updates SQL history will be usable and thus tab history unnecessary but there's no telling how many updates that…
20 votes -
SQL Rule/Issue/Error Search
Like SQL Search, but SQL Error/Issue/Rule violation.
This would list all issues that exist in a database.
Example: "Non-scalar subquery in place of a scalar value"Because these issues can cause major slowdown in queries, and it would be great to have a way to search a whole database to find these rather than having to open all the views, procedures, and functions to find all these things.
2 votes -
New Case When Intend option
The new option would allow intending from alias (in alias = expression notation)
5 votes -
IntelliSense for $partition.<partition_functions>
I would like the Prompt to be able to list any partition function found in the current context (DB)
like when i write: $partition.<Intellisense here>1 vote -
In the SQL History tab, under Advanced Search, allow us to set a default server and database
In the SQL History tab, under Advanced Search, allow us to set a default server and database or remember the last one that was chosen. I have about 30 servers in my list and most of them no longer exist. I would never want to search all servers. I would also rarely want to search another database besides the one I usually search.
2 votes -
save /copy result grid as html table
SQL Complete has a great feature to allow copying the result as html table. I wish this feature was available in RedGate. This is the feature I would use multiple times every day.
1 vote -
SQL history - Allow user to set custom SqlHistory.db save location
SQL Prompt allows users to set custom directories for various files.
It would be nice to be able to change the location of the SqlHistory.db and other files that load to localappdata.
I would love to have this update to a folder in my oneDrive folder so it is backed up and easier to migrate between computers.
The only way to do this now is via REGEDIT.
6 votes -
"Open in Excel" feature should use the default Excel template
In the "Open in Excel" feature, I'd like the resulting Excel workbook to auto-open using the default Books.xlst template file locatedi in the %AppData%\Roaming\Microsoft\Excel\XLSTART folder.
1 vote -
Formatting Styles should include Global Style parameters
Global formatting options like "Insert Semicolons", "Add brackets to all identifiers" etc should be part of a formatting style, this way changing a formatting style can also quickly switch between these options.
Currently even after changing a formatting style these options on the screenshot below had to be manually changed one by one, it's inefficient to say the least.3 votes -
Turn off SQL Prompt+ AI
Please can there be an option to turn off SQL Prompt+ AI. It is a pointless feature that I have found no benefit from. It locks up and crashes SSMS. It also it an extremely intrusive feature constantly displaying the icon next to the cursor
1 vote -
Create snippet to apply on each line in the selected text.
I really love the add (quotes and) commas feature in SQL Prompt. Unfortunately we cannot produce a snippet similar to those.
If you select some text it would be nice to format each line to a certain format.
Like for exampleE46337E5-ECBC-41D4-A63E-A994E16BD8F7
669F0B8E-5E1C-47CE-A799-81B47C9BC045
65D23D56-7EB8-44AE-9158-C3D8B5684357
AAFE4057-10B9-4AE8-BE76-C22537D29790
4426C0B6-6216-4BFE-BE54-C1D917B593A5
7BC5ED9E-E8C3-4618-B625-786F4B931D97
01A37706-63FA-46E5-99EE-293FF290B34D
94CAB432-EA1C-4972-8CD6-3C8B9E1A096B
2C801ADE-995A-4158-9D0A-7DA03911D093
425BAAC6-6A0B-419C-B393-79B21A628538turn into
('E46337E5-ECBC-41D4-A63E-A994E16BD8F7'),
('669F0B8E-5E1C-47CE-A799-81B47C9BC045'),
('65D23D56-7EB8-44AE-9158-C3D8B5684357'),
('AAFE4057-10B9-4AE8-BE76-C22537D29790'),
('4426C0B6-6216-4BFE-BE54-C1D917B593A5'),
('7BC5ED9E-E8C3-4618-B625-786F4B931D97'),
('01A37706-63FA-46E5-99EE-293FF290B34D'),
('94CAB432-EA1C-4972-8CD6-3C8B9E1A096B'),
('2C801ADE-995A-4158-9D0A-7DA03911D093'),
('425BAAC6-6A0B-419C-B393-79B21A628538')OR even better
prepend
SELECT t.x FROM (VALUES
and append
) t(x)
I often use this format to look up data in the database. I know I can achieve this with Excel and consorts. Or even with…
6 votes -
Release notes
When you do a new release of SQL Prompt it will popup thru the existing install of SQL Prompt saying that there is a new release. There is a link on there to the release notes. PLEASE UPDATE THE RELEASE NOTES WEBSITE TO DESCRIBE THE NEW RELEASE. The website is usually a version behind. The problem is there is a new release and no idea what it fixes or addresses.
Just installed Version 10.14.11.7894 and I do not know why...
1 vote
- Don't see your idea?