93 results found
-
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 -
export to excel bug(?) -- Acts odd if multiple result sets
Before I upgraded to latest version of SQL Prompt, if I had two queries in the same "New Query" window and ran them, I could select either of the two result sets and choose "Open in Excel" to open up the selected result set in Excel. Now it always seems to auto-select the first result set.
What I'm usually doing here is two related queries. I pick the larger result set, open that in Excel, and then add a new tab to Excel and copy-and-paste the smaller result set to the 2nd tab. Or sometimes I'm doing multiple queries to…
3 votes -
Include snippets in command palette searches
It would be useful to have snippets included when searching in the command palette. Selecting snippet would open snippet editor with focus on the selected snippet.
1 vote -
Click to run pinned queries
I often find myself in a scenario where I am doing something like:
1. Mock some data (SQL query)
2. Perform a front end action as though I'm a user
3. Check some data (SQL query)
4. Alter a procedure (SQL query in a different window)
5. RepeatI think it would be nice if I could pin the mock/check queries to a window in the side of the manager so that I could click to run them instead of having to click in them then shift+f5 or whatever. And even more nice not having to have a second editor…
1 vote -
Version Specific Snippets Script Blocks
I would like to be able to specify different script blocks inside a snippet that would work differently based upon the sql server version of the server I am connected to.
Or.... optionally have a version indicator on the snippet to perform the same thing. Then if two snippets share the same name it would apply the correct one based upon version.
EX:
…:if $version_major$ >= 13 CREATE OR ALTER PROCEDURE [$dbo$].[$proc_name$] (@param1 INT) AS BEGIN $CURSOR$SELECT @param1 END GO :else IF OBJECT_ID('[$dbo$].[$proc_name$]', 'P') IS NULL BEGIN EXEC('CREATE PROCEDURE [$dbo$].[$proc_name$] AS BEGIN SELECT 1; END;') END GO ALTER PROCEDURE [$dbo$].[$proc_name$]
1 vote -
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 -
Allow a Dark Theme for the Toolbelt GUIs
Allow dark theme for all GUI interfaces in Prompt.
2 votes -
Tab Color accessibility compliant
Tab Colors add a great feature to know I am on a production server. It would be improved by being accessibility compliant. In the attached you can see black on red is harder to see than white on red.
1 vote -
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 -
In the tables population dialog allow more filtering options - say, filter by schema, by name, etc
Allow more filtering options for populate tables with data tool.
1 vote -
Export settings doesn't export snippets
When I export my settings, my own snippets are not exported.
4 votes -
Fix the confusing multiple usage of your company name
You should fix the use of multiple versions of your name (Red Gate | Red-Gate | Redgate | redgate | red-gate) across all software and communications. See attached picture.
We try to promote your products in our consulting company, but everyone uses a different name to refer to your company.
4 votes -
Draw line from begin to end of different colors
It would be nice to have colored lines that visually enhance the start / end of a while / if statement
4 votes -
Surround with, add to the list Select, Pivot, and I am sure there are more items like CTE
Surround with, add to the list Select, Pivot, and I am sure there are more items like CTE
1 vote -
simple tabs (brent ozar)
https://www.brentozar.com/archive/2011/06/fixing-sql-server-management-studios-tab-text/
Brent Ozar wrote this tip back in 2011 and I cant believe i've been struggling with the horrible SSMS tabs every day for my whole career. would be great if SQL prompt has a button to change these settings for you or defaults these options when you install it.
the main reason being that they are buried away and if I wasnt aware of them then i'm sure many others aren't.
at the end of every day i have about 10 tabs open and i just close the whole lot because it's too hard and to go through them…
4 votes -
Dark mode support
Dark mode support across all red gate tools.
10 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 -
I would like to be able to re-name a tab without actually saving it off as a sql file.
I would like to rename tabs without having to save them as a .sql file to the filesystem. I run with alot of tabs all the time and it gets very difficult if you don't name them to find a tab that has floated into the dreaded drop down arrow. Once its there I have to walk through the whole contents of the drop down list of query windows to find the one I want. With a simple rename of the tab that could be managed by the solution file. I would be able to label them and track them…
4 votes -
Custom Aliases - Ability to Alphabetize by table name
Custom Aliases - Ability to Alphabetize by table name
4 votes -
Fix the confusing multiple usage of your company name
You should fix the use of multiple versions of your name (Red Gate | Red-Gate | Redgate | redgate | red-gate) across all software and communications. See attached picture.
We try to promote your products in our consulting company, but everyone uses a different name to refer to your company.
1 vote
- Don't see your idea?