87 results found
-
Bookmarks
Bookmarks is a feature of SSMS. But all my bookmarks are destroyed once the code is formatted. So, as SSMS' feature is not so good as I want I do suggest to implement this feature by RedGate.
3 votes -
Copy as IN clause" on a resultset - put results all on one line
With SQL Prompt, and selecting "Copy as IN clause" on a resultset, is it possible to format the result as all one line, like:
IN (1,2,3,4,5,6)
instead of what it does currently:
IN (
1,
2,
3,
4,
5,
6) ?
Having it all on one line makes a statement easier to read, when there are a lot of items in the list.
2 votes -
Allow save and re-load a set of filters. We work in schemas by project and every morning starts with filtering all my objects by schema, ana
Allow save and re-load a set of filters. We work in schemas by project and every morning starts with filtering all my objects by schema, and I would love to reapply filters as a set.
2 votes -
auto create table from excel
i have file excel multi column about 100 column.
I suggest feature, when i open excel, auto create struct insert table.2 votes -
Allow a Dark Theme for the Toolbelt GUIs
Allow dark theme for all GUI interfaces in Prompt.
2 votes -
Copy as where
It would be very useful to be able produce where clause from copied horizontal selection from the results grid. For example from the uploaded image, where clause should be
WHERE CTA.TRANSACTIONDATE = '2021-06-27'
AND CTA.TRANSACTIONTYPECODE = 52
AND CTA.ITEMCODE = 1500012200
AND CTA.ITEMBARCODE = '8001841964966'
AND CTA.YOURCOMPANYCR = 104183
AND CTA.OTHERENTITY_CR = 460842 votes -
Prohibit SQL execution in case of UPDATE/DELETE without clause
At the moment a user is warned before executing a potentially dangerous operation.
However, junior devs might accidentally just press enter without thinking twice.
Please add functionality to PROHIBIT execution besides WARNING (like SSMS Boost has) so that junior devs can't make mistakes at all.
It would be fantastic if this would be possible.2 votes -
Follow the Visual Studio Theme
I'm running a dark theme in visual studio. When the suggestions pop up they are very bright.
2 votes -
Macro Recorder
Create a plugin to record and replay keyboard commands like notepad++ or sublime.
2 votes -
Using Ctrl-F12 to jump to object - Refresh if required
I often use the Ctrl-F12 feature to jump to an object in the object Explorer, however this doesn't work if the object has been renamed, or was just recently created. In those cases I need to manually refresh the object Explorer before I can use F12. Perhaps the F12 feature could do that for me? (or prompt if it can't find the object)
2 votes -
Add a hotkey that will expand the selection to envelop the current statement
Pressing control+A will select an entire document.
I'd like a control+k, control+A to select the current statement based on cursor position.This would enable me to do a few things:
01. Format the current statement with a hotkey
02. Copy or cut my current statement so I can paste it somewhere elseThanks.
2 votes -
Disable prompt for major version upgrade when current license doesn't support it
Disable prompt for major version upgrade when current license doesn't support it
2 votes -
Highlight difference between selected rows
Time to time you need to compare data in the rows, for example when looking for the cause of duplication. If the query is complex enough with joins and wide tables I usually run
SELECT * FROM ...
and check where the duplication begins to easily find the root cause. The easiest way for me to do so is to copy it into the excel and do some simple formula to find the exact columns that have difference.
It would be nice if SQL Prompt would support that feature. If it's possible then it can be done by highlighting needed…
2 votes -
Allow query results to be editable grid
I would like to have the ability when using Redgate to develop a query as I do today in a new query window with all the object search and suggestions features currently offered in your product.
After I get the query returning the correct record set, I want to be able to edit the record set without having to copy the query and navigate to SSMS’s “Edit Top XXX Rows” menu item.
Editing a field on the row would update that field on that row when I move off the row.2 votes -
Provide optional colors for Warnings & Highlighting > highlighting
Options, Warnings & Highlighting, Highlighting. The light gray does not work well on a black background. I'd like to be able to select another color for that feature.
2 votes -
Load tabs into prior windows on SSMS startup
Currently I have query tabs in two separate windows within SSMS to view data and queries side by side. After closing and re-opening, it would be great if these segregated tabs went back into their appropriate windows. Along with that, it would be great if it would only load back in the tabs for the server we are connected too. Not also the tabs that I had open in a different instance of SSMS to a different server; which I had displayed on a different monitor for more side by side viewing.
2 votes -
Additional syntax coloring - override SSMS
So I'm not sure if this is something that SQL Prompt has the ability to do or not as far as access to SSMS.
When you customize syntax coloring in SSMS, it sees variables, tables, column names, etc all as the same thing...."Identifiers"....I would love it if I were able to specify a different coloring scheme for variables, separate from the rest of the identifiers.
2 votes -
filter snippets between default and custom
Ability to easily identify user-created snippets from default Redgate snippets.
I love snippets and I create a ton of them, but there's no easy way for me to filter the list of snippets to see which ones I created vs the ones that shipped with the product. I'd love the ability to be able to filter the list of snippets to show my custom snippets so I can find them easily.
(My work around is just to use a naming convention that groups them all, but this feels inefficient because it requires that I type more letters to activate the…
2 votes -
Colors Option For Different Databases
Colors Option For Different Databases
2 votes -
Include BEGIN TRANSACTION with "Execute Current Statement" (Shift-F5)
While using Shift-F5 to execute the current statement, any BEGIN TRANSACTIONS above your UPDATE are ignored, running it not in a transaction.
I shouldn't use Shift-F5 probably, but it's becoming a habit and could be very expensive when forgetting to highlight-execute.2 votes
- Don't see your idea?