663 results found
-
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 -
Script as Insert - Floats end up with innacurate data precision
After running a select on a table with a float(53) column, "Script as INSERT" from the right click menu on the results will script an insert with float(8) as the data type instead of float(53), presumably from the length of the column being recorded as 8 bytes when the float(n) is defined with n being bits.
Minor thing, but ended up causing issues with an equal statement since the floats had different precision when comparing to the original table.
1 vote -
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 -
Finding tabs with the same code
Hi, the possibility to sort/show tabs with the same code. Then you can delete history if you have more than one tab with the same code. This will make history smaller and faster.
7 votes -
Tab History - Option to Open Multiple Tabs at Once
I use Tab History quite a bit, and I often find myself seeing 2 or more tabs that have the search criteria I'm after. Rather than just being able to click one tab to open it, it'd be nice to be able to select multiple tabs from the history (some or all of the result list). The amount I use it daily and the amount I need to open 2 or more tabs from a search this sort of functionality would save me the repetitive task of performing the same search over and over to get each tab open that…
12 votes -
Dark mode support
Dark mode support across all red gate tools.
9 votes -
Custom Aliases - Ability to Alphabetize by table name
Custom Aliases - Ability to Alphabetize by table name
4 votes -
Add support for LEAST and GREATEST
Please add support for the new SQL functions LEAST and GREATEST. Currently only available on Azure DB.
Information (can't find official Microsoft documentation): https://www.linkedin.com/feed/update/urn:li:activity:6737816854498291712/3 votes -
Tab History - Closed tabs
It would be nice to have an ability to use either CTRL + click and SHIFT + click combos or to have check boxes there in order to select multiple closed scripts for a removal from Tab History instead of repeatedly hitting Remove context menu choice. It should save developer's time. Check boxes would be even better implementation choice, because that way you can apply context menu choice to a selection of scripts. Yay!
Thanks!5 votes -
Ability to make/see notes about servers
It would be very handy if there was a way when you open a server in Object Explorer that it pops up with notes about that server. For instance, there is a job we have on EVERY server in our environment except one random server that no one hardly thinks about. But if that job is there, then it messes up things. It would be great if when anyone on our team who has redgate sql prompt opens that server they get a reminder that we add on there that says some special note (in this case “DO NOT ADD…
2 votes -
Multi Line Comment shortcut
Add /* / multi line comment shortcut for highlighted code in text editor. See SSMSBoost pro for example CTRL+.
2 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 -
Cloud Backup of all SQL Prompt Settings
Hi guys,
SQL Prompt is great. What is less great is migrating from one computer to another (or rebuilding your machine / VM / whatever).
It would be super useful if we could have a cloud backup of all SQL Prompt settings, styles, and snippets which can be associated with our licence account.
When we do an install on a new machine, we'd then be given the option to restore settings from the cloud.
4 votes -
Custom Aliases - Ability to Create a List to Import
Custom Aliases - Ability to create the list and import without having to use the SQL Prompt - Options-New... Interface. Reasons: Speed and to alphabetize.
3 votes -
Separate UDF Formating from Built-in in "Function Calls"
We cannot treat UDF parameter listing/indentation in similar vein to Stored Procedure call formatting. All "Functions", be they UDF or built-in, are lumped into the same four RESTRICTIVE options on the "Function calls" page, and we have no "parentheses style" options for them.
We need:
1. Separation by type (UDF vs. Built-in).
2. Global ==> Parentheses, to apply to UDFs, by our choice.Thanks.
1 vote -
Make the "Enclose identifiers within square brackets [ ]" option persist
Currently in Visual Studio the option to "Enclose identifiers within square brackets []" option will be set to true on startup requiring a user to turn it off every time they load Visual Studio.
This option when set to false should remain that way even after a restart of Visual Studio the same way it does in SSMS.
2 votes -
Add NULL to JOIN suggestions
When joining two tables, you today get the option to join on known references or identical column names.
What I would like to see is an extra join option in the suggestions, if both the columns are NULLable:
SELECT * FROM table1
INNER JOIN table2 ON (table2.ref1ID = table1.ref1ID OR (table2.ref1ID IS NULL AND table1.ref1ID IS NULL)The above example might seem like rubbish at first! But sometimes when you have composite keys, one of the columns in the key might very well be a NULLable value.
So a more valid example would be:
SELECT * FROM table1
INNER JOIN…1 vote -
Copy results as Markdown Table
When right-clicking in the results tab, SQL Prompt should offer the posibility to copy the results as a table with markdown formatting (for Stack Overflow / Stack Exchange network). See https://meta.stackexchange.com/questions/356997/feature-preview-table-support for the syntax.
3 votes -
Aliases Postfixes to ignore
Similar to the "Prefixes to ignore" option in Options > Inserted code > Aliases, could we have a "Postfixes to ignore" option to allow use to set words at the end of a tablename to ignore when generating aliases.
Currently I have to keep the custom aliases list up to date, whereas this would do that automatically.
2 votes -
set default join conditions
I work on the same databases on a regular basis. Many do not have foreign keys and do not used identically named column names in tables that I'm joining.
I repeatedly have to specify the same several columns in the join condition.
I'd love a way for SQLPrompt to either remember join clauses I've previously used, or allow me to specify default join conditions for pairs of tables (or both).
8 votes
- Don't see your idea?