663 results found
-
open excel with different account
Configure a different account than the one opening SSMS to open Excel for results. We use an Admin account for DBA work separate from our Windows account.
3 votes -
VSCode integration.
I've used SQL Prompt for 20 years. I would LOVE VSCode integration.
3 votes -
Sql prompt support for Dedicated SQL pool
Add support for Dedicated SQL pool on Azure Synapse.
3 votes -
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 -
AI
AI suggestions.
I'm not part of your AI program waiting list. However here what I suggest.
Do not make the AI part of your program an only cloud-based solution. There are plenty of opensource code models free for commercial use that can be ran locally on a PC. These models can also run under CPU but will up the memory to enable this feature requirements for AI on client side only. It's too dangerous for Redgate to store this information on the cloud even with a solid EULA, and laws are subject to change. Please offload this burden back to…
3 votes -
Add a table alias as a prefix to selected column names
I would love an option where, after adding an alias to a table, you can add it as a prefix to all columns coming from that particular table at once.
Some keystroke like Ctrl + F2 would be nice.
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.
3 votes -
Add Trim() to LTRIM(RTRIM()) toggle
For those of us who have to move between current and older versions of SQL Server, provide a tool to toggle all TRIMS in a script to LTRIM(RTRIMS()) and vice versa to make it easier to adapt scripts when moving between server version.
Thanks,
Mad Character Trimmer3 votes -
Export snippets to text file
At times you do not always have the luxury to have SQL Prompt installed on all machines. Hence, it is extremely useful if snippets can be exported to a plain text file, so that at least one has the ability to retrieve the much needed sql scripts quickly via plain text files. It would be of great help if each snippet is exported to an individual text file that should be named like the snippet name.
3 votes -
Prompt Styles As Buttons
I've created a few different style templates and named them accordingly, but when I want to add them as buttons to quickly change between styles, there is just a list of styles with no label so I don't know what any of them are.
So I have to trawl through and add each of them as a menu button until the one I want appears, which is incredibly frustrating and time consuming! When its on the menu bar as a button, it has the appropriate name rather than just "style" so can this be added to the add button menu…
3 votes -
Replace the option Remove square brackets with Toggle square brackets
I usually enclose database and server names in square brackets.
Instead of only removing the square brackets, you could change that option (keeping its keyboard shortcut) to toggle between adding and removing them.3 votes -
Stop Overwriting Existing Features With new Alternatives that Aren't Merely Updates
The recent roll-out of SQL History was handled very poorly. SQL History isn't simply an update to Tab history else there would not have been the need for a name change. SQL History is an alternative feature meant to do what Tab History does (I hope) and more but on roll-out it made many of your paying customers not only angry because you replaced Tab history with it but because it wasn't ready for roll-out.
In the future when you feel the need to replace an existing beloved feature with something different and not just an update, DON'T! Instead roll…
3 votes -
snippet refresh
Snippet adds or updates are not refreshed until SSMS is restarted.
Can you add a feature to auto refresh the cache of snippets or make part of the "refresh suggestions"
3 votes -
Operators configuration depending on where they are placed
There is a general configuration for operators AND/OR. However, for us it is important to distinguish between the different places they are used:
- JOIN
- WHERE
- CASE ...
Would it be possible to configure the AND/OR options inside each block?
3 votes -
Create shortcut to filter setting
Hello Redgate and the community,
During my day to day work, it would be greatly helpful to get a shortcut to enter the filter setting menu, not only on databases, but also tables, views and stored procedures and what not, just a global shortcut, to enter the filter setting on the selected folder (if that is available for the folder)3 votes -
New Code Analysis Rule: Flag system named constraints
It is generally bad practice to use system named constraints and there should be a rule for flagging them when there is DDL code creating one.
3 votes -
Script as Insert #tempTable to snippet/placeholder text
When using the Script as Insert, it generates the Create Table with the table name as
#temptable. If you want to change that name, you have to then change it in the Create, Insert, and Drop locations.
Would be nice if this defaulted as a snippet placeholder so that editing one would edit the other two as well.3 votes -
Open in Excel / Export to Excel - Choose file location for file creation
Currently the files write out to a temporary file location. Add pane in settings window to change the location (e.g. a folder in my one drive that is not read only)
3 votes -
Add AI assistance
As AI powered tools like codepilot, kite or tabnine are on the rise, It would be so great to add an AI assistant to SQL Prompt to support developers on their way to write t-sql code effortless.
3 votes -
foreign key follower
There is a feature that was in WinSQL where each field in a column would have a little plus sign if it had a foreign key. If you click the plus sign it would look up that value in the table with the foreign key in a new tab (it would give a choice of tables if there are more than one, then do the lookup).
It was very useful and a great learning tool; it would be a great addition to SQL Prompt. Pictures attached.3 votes
- Don't see your idea?