276 results found
-
toggle SQL Prompt from toolbar
I frequently need to work on longer procedure or scripts, and the longer the script gets Sql Prompt gets more and more bogged down, to the point I just turn it off. It would be nice to be able to toggle it from the toolbar rather than open the options to un-check 'Use SQL Prompt'
6 votes -
Resizable Options-form
It would be great if the Options-forms was resizable (and the formsize was stored when closing the form).
The 'Sample SQL' textbox would then be larger so all SQL code is visible with the formatting options that are chosen.
6 votesThe options form is now resizable in SQL Prompt 6.2 which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Allow SQL Prompt to work with no access to master.sys.sysservers table
SQL Prompt fails when the user does not have access to the sysservers table in master database. It is becoming increasingly common for DBA groups to revoke/deny this permission to developers. For our org it was the result of an independent audit/penetration test. There are other procedures etc the provide the same information without this specific access. I have provided examples and troubleshooting steps to Redgate support but with no resolution. Their suggestion was to post a request here.
5 votesHi,
We released this feature in SQL Prompt 10.3.3. The only reason SQL Prompt ever needed to query the master database was to get the list of linked servers. If you upgrade to that version and ensure the “load suggestions for linked servers” option is disabled, SQL Prompt should load suggestions correctly.
Thanks,
Tom
SQL Prompt Team -
Allow the option for SQL formatting of nested inner join on an outer join to indent the nested inner join.
When you have a nested inner join to an outer join, such as:
SELECT a., b., c.*
FROM
A a
LEFT JOIN B b
INNER JOIN C c on b.bid = c.bid
ON a.aid = b.aidIt should allow an option to indent the nested join further to show that it is nested
5 votesWe’ve released support for indenting nested joins in version 8 of SQL Prompt as part of our new formatting system.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
If there is something missing please let us know by opening a new suggestion.
Kind regards,
The Prompt Team
-
highlight all columns and filters for a table alias when that alias is selected
when selecting a particular table alias, can you highlight all places where that alias is being used like in notepad++
5 votesWe’ve added the “Highlight matching objects” experimental feature in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
When coding ALTER TABLE xxx DISABLE TRIGGER, list just that table's triggers, not every one on every table
The suggestions list after the TRIGGER is full of triggers. SQL Prompt, having been given the schema and table should narrow that list to only those present on the table to be ALTERed.
I would categorize this as a bug, rather than a suggestion...
5 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Formating create table command
Currently when formatting a Create table command the SQL Prompt is moving the "Default" to a next line and indenting it...
like this
[insertDT] DATETIME NULL
[______INDENT] DEFAULT GETDATE()
,[ActualMU] INT NULL
[___INDENT]DEFAULT 0
,[PlannedMu] INT NULL
[___INDENT]DEFAULT 0
,[CompletedDT] DATETIME NULL
[___INDENT___] DEFAULT GETDATE()And the format that I would like to see (making easier to read) is
keeping all definition of each field in the same line, like,[insertDT] DATETIME NULL DEFAULT GETDATE()
,[ActualMU] INT NULL DEFAULT 0
,[PlannedMu] INT NULL DEFAULT 0
,[CompletedDT] DATETIME NULL DEFAULT…5 votesThis feature was released in version 8 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team -
Stop auto Uppercase conversion of keywords in comments
When a word is entered in a comment block, that is the same as a keyword (e.g. FROM), SQL Prompt should not automatically convert the word to uppercase.
5 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
SQL Tab Magic - Recently Closed Tabs navigation
When I click on 'Recently Closed Tabs' I get a window showing 20-ish closed tabs and their contents. If I resize the window, it fills with more, so I know that further history can be accessed.
I understand that the best way to find 'old' queries is to type in the search box to try and filter the history, but sometimes (and it is only sometimes) I just want to scroll down the history and see all the closed tabs. Not saying all the history should be loaded - I guess that would take a lot of memory, but it…
5 votes -
Don't expand wildcard within EXISTS
Don't expand wildcard occurrences within EXISTS clause.
WHERE EXISTS(SELECT * FROM tab1)
should not expand to
WHERE EXISTS(SELECT col1, col2, col3 FROM tab1)5 votesSQL Prompt 6.2 doesn’t expand wild cards in exists statements, you can download it from http://www.red-gate.com/products/sql-development/sql-prompt/
-
improve performance in SSMS when CTE statements are in the script
Or maybe an option to disable parsing of statements using CTEs. My keyboard takes seconds to respond when several CTEs are in the script.
5 votesWe’ve just released SQL Prompt 6.1 which shouldn’t slow down typing when CTEs are used
-
unformat
It would be nice to select a small already formatted script, and unformat it by putting it into one line.
5 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Enhance Press tab to expand
Right now, if I have
Select * From TableA As ta
Inner Join TableB as tb On ta.Key = tb.Keyand I "Press TAB to expand wildcard" only the fields that are in common get qualified with the table aliases. I would like to see an option of ALWAYS having the table alias added even if there is only one table.
5 votesFeature was already present through options.
-
Quicker way to disable / enable
Some users report that having to go into options to disable prompt temporarily is long winded. Can there be a quicker way (perhaps a keyboard shortcut or direct menu option)?
5 votesI’m going to close this idea to return your votes since I think it was completed a while back (you can disable suggestions with Ctrl+Shift+P or from the Prompt menu). If I’ve misunderstood then feel free to create another idea with more specifics.
-
Recognize the DateTrunc function in T-SQL.
The formatter is not recognizing the newish DateTrunc function in T-SQL, so formatting and intellisense do not work on SQL statements that include DateTrunc.
4 votesShipped in version 10.13.10: https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-13-release-notes
-
Autofix with shortcut
A shortcut to implement the autofix changes.
Would be nice if it wasn't necessary to use the mouse when applying autofixes.It is almost there; you can press ctrl and get the error window and even just press enter then, to apply the fix. But the window stays and there is no reason to actually open the window, the fix could/should just be applied
4 votesWe added the ability to autofix issues using the Alt + Enter keyboard shortcut in SQL Prompt 10.1.
-
transparency
Hi, new feature with transparency on Ctrl in SQL Prompt 9.4.10 is extremely annoying, I'm using only Ctrl+Space to show intellisense. Please provide us option to disable this feature, or change key to Alt or Ctrl+something, this is really horrible, please fix it asap. I've to uninstall tool for now.
4 votesMany thanks for your useful feedback on this issue.
We’ve done some further work on this feature that should hopefully address your issues. This has just been released in SQL Prompt v9.4.11 (available from https://www.red-gate.com/products/sql-development/sql-prompt/).
The popups will now only go transparent after holding the Ctrl key for a short period instead of immediately. This should mitigate the issue somewhat. In addition, there is a new option (in Suggestions → Behavior → Make popups transparent when the Ctrl key is held down) to turn the feature off if it is not wanted.
Kind regards,
The Prompt Team
-
Duplicate Tab
One of the common UI interaction features in browsers like Chrome and IE is Duplicate Tab feature.
Ususally the reason you might want to do this, could be because you want to keep an UNALTERED TAB and do SOMETHING DIFFERENT with another page...
In SSMS this could be a great feature. Example of use please (- I hear you ask)? You could be trying to change script and test the effect of that change vs the original!
MUCH MUCH Further down the line, you could extend this feature, to highlight the differences between tabs, a bit similar to file compare…
4 votesHi,
We’ve added this to SQL Prompt and it will be shipped in the next release.
Thanks,
Owen
-
OPTION
Hi!
Would be good to control the formatting of the OPTION clause.
I personally prefer to have it on a new lineSELECT
*
FROM
Production.Product p
LEFT JOIN
Production.ProductSubcategory s
ON
p.ProductSubcategoryID = s.ProductSubcategoryID
WHERE
p.ProductSubcategoryID = 14 OPTION(QUERYTRACEON 8757);
GO--should look like
SELECT
*
FROM
Production.Product p
LEFT JOIN
Production.ProductSubcategory s
ON
p.ProductSubcategoryID = s.ProductSubcategoryID
WHERE
p.ProductSubcategoryID = 14
OPTION(QUERYTRACEON 8757);
GOThanks!
4 votesThis feature was released in version 8 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team -
formatting stored proc
I love to have the options so that the first line of a stored proc is just the name i.e. create proc spName and the @parms varchar(20) and following would be on additional lines
So for examplecreate proc spName
@Parm1 int
,@Parm2 intthanks
Shannon4 votesThis feature was released in version 8 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team
- Don't see your idea?