78 results found
-
Fix high resolution display support !!
When SQL Prompt loads the database objects, the resolution on my Dell M3800 gets screwed up. I can restore it by checking for updates.
1 voteHi
Thanks for your suggestion. This sounds more like a bug than a feature, although we’re not currently aware of it. Please could you raise a support ticket with screenshots and recreation steps at: https://redgatesupport.zendesk.com
Thanks
-
try_cast
Hi support,
Please add TRY_CAST to you list of key words in SQL Prompt.
Best regards,
Henrik
Henrik Staun Poulsen
Vestas Data Center
Vestas Technology R&D
1 voteHi Henrik,
Unfortunately the script syntax highlighting is not handled by SQL Prompt. It’s something that’s built into SSMS and so we don’t have control over which keywords get marked as pink.
-
Disable duplicate parentheses correction ))*
1º Disable/enable duplicate parentheses correction ))* option
example : Select ISNULL(dbo.InitCap()
in * position to tipi parentheses ')' SQL Prompt eating this
res: Select ISNULL(dbo.InitCap()
2º right-click > Format SQL > [Sub Menu] Style
, for quick access to alternative formatting setting
3º I Still Waiting For Numeric Data type LENHT in definition box, tooltips and suggestions box
and 4º most importantly is highlight similar words1 voteHi David,
I’m going to close this idea as its really 4 ideas which means it’s difficult for us to know which one to work on if other users start voting on it. We also already have individual ideas for each of these so closing this one will give you the points back and allow you to add them to those.
Thanks,
Aaron. -
Working with multiple servers.
Executing code on multiple servers and with check boxes choosing on which to execute for fast on/off.
Also procedure comparison and altering on multiple servers.
So all in all enabling easy management for multiple servers and instances of SQL Server. Registered Servers feature in SSMS i just too blunt.1 voteHi Hrvoje,
I’m going to decline this suggestion as I don’t think it fits in with Prompt at the moment. We have another product called SQL Multi Script that has some of the functionality you’re requesting for multiple servers.
Thanks,
Aaron. -
Intellisense improvement : Write the FROM automatically for the user based on the SELECT
The idea is that we don't have to go back with the cursor and can always type forwards, not interrupting our flow/thinking
For Example,
User types:
SELECT Master.Active,Prompt now makes it
SELECT m.Active -- Cursor stays here
FROM Master mWe still start with the SELECT but mention the table which is an indication to Prompt to wrote the FROM automatically after that.
Now we start with the from and go back to the select which is cumbersome if you have to do it 100 times a day.
This feature is also more natural to find because the developer…
19 votesThank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
Currently, we have no plans to implement this feature in the near future. However, if there is sufficient demand in the future, we will revisit it.
Please feel free to send us any additional feedback on these topics by commenting here.
Kind Regards,
The Prompt Team -
Bugs
SSMS shuts down when I bring my computer back from sleep mode. I think it's due to SQL Prompt. Also, SQL Prompt could do a better job recognizing CTE's. Furthermore, when referencing a table function in a query the formatting is very clean. It often times puts each string input on a new line. Formatting should be improved around strings / inputs separated by commas.
1 voteHi Devin, I’ve sent you an email asking for more details on the bugs you mentioned but I’m going to close this idea as it’s 3 in 1 which makes it awkward to complete or vote on.
-
2 votes
Hi Eric,
We haven’t received a response and are unable to recreate this bug here so we’re going to close down this feature request. If you’re still experiencing this please send us some more details.
-
Implement Collapsable Regions
Developing a script of some size becomes very tedious when going back and forth, and the script quickly becomes unwieldy.
Add collapsable regions driven by specially formatted comment (--#Region [name/description/comment] ... --#EndRegion, or some other suitable notation).
70 votesWe’ve had a look at this feature and found a potential existing solution using
BEGIN END blocks in SSMS 2016+e.g.
BEGIN —this is a “region”
SELECT * FROM TEST;END
We’re not planning to do this in the near future because of the effort required to support all versions of VS and SSMS that Prompt is available on.
Kind Regards,
Prompt Team -
Can "Swap order of columns in join clauses" be enabled automatically if upgrading from an earlier version e.g. 5
WIth the change in v6 to default to
SELECT * FROM table1
INNER JOIN table2
ON table2.id = table1.idwhereas previous versions used this format.
SELECT * FROM table1
INNER JOIN table2
ON table1.id = table2.idIf upgrading from an earlier version, can either the swap order option be enabled or at least the user warned during installation that the intellisense options have changed and that queries will be formatted differently.
1 voteThanks for your suggestion Kieron.
In adding this new option, we set the default column order to what we think will be the most useful. If you prefer the old behaviour, select the new option – your option preferences will be persisted when you install new versions of SQL Prompt.
-
Format CTEs to keep the semicolon on the same line as the "With"
When you format:
SELECT x from y
;WITH NumberSequence ( MonthNumber )
AS ( SELECT 1 AS MonthNumber
UNION ALL
SELECT MonthNumber + 1
FROM NumberSequence
WHERE MonthNumber < 12
)You move the semicolon to the end of the previous command instead of leaving it with the CTE and remove the blank line:
SELECT x from y;
WITH NumberSequence ( MonthNumber )
AS ( SELECT 1 AS MonthNumber
UNION ALL
SELECT MonthNumber + 1
FROM NumberSequence
WHERE MonthNumber < 12
)Should leave the blank line and semicolon where they are.
Thanks,
Tom
20 votesThank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
We’ve decided not to implement this feature as there is not enough evidence/demand at this point in time to justify its implementation.
Kind Regards,
The Prompt Team -
Format SQL suggestions (first impression from week 1 of 15-day trial)
I'd like the ability to align my parenthesis with the start of the line above it like so:
SELECT
column1
,column2
,column3
FROM
table1
WHERE
tableID IN
(
1
,2
,3
)I would also like the option to never insert more than 1 space between words in a line.
I don't like that there is a full tab between WITH and TARGET below. TAB the whole line or nothing. I can't find a way to get rid of this.
;
WITH TARGET
AS (
SELECT
Column1
,Column2
,Column3
FROM
table1
)A keyboard shortcut to add commas to a…
2 votesStephen,
I’m so sorry about the UserVoice formatting issues. I’m going to contact their support to see if this can be fixed. For now, can you please post this in our support forum at http://www.red-gate.com/messageboard/viewforum.php?f=137.
Davin,
I’ve declined this suggestion because it contains too many suggestions. Please post each suggestion separately so other users can vote on individual suggestions, which will help us prioritize work. There are some really good ideas here and we appreciate the feedback.
-
Need for automatic "where" concatenation
When you are working with SQL it is easy to forget the "where" statement in update, delete. If this happens in production it could be devastating. It would be a nice feature to automatic add the "where" statement in for "delete" and/or "update".
19 votesThank you for the suggestion.
Prompt already provides execution warnings when you use an UPDATE or DELETE statement without a WHERE clause and code analysis also flags this as an issue. Please see the comments below for other options for solving this issue.
You can get the latest version of SQL Prompt, including all of the above, from http://www.red-gate.com/products/sql-development/sql-prompt/.
Thank you for your help!
Kind regards,
The Prompt Team
-
My coding preference is to place commas at the beginning of a line, NOT the end. Can you make the placement a config option?
My coding preference is to place commas at the beginning of a line, NOT the end. Can you make the placement a config option?
If you would like I can explain why this is much better than having them at the end of the line.
5 votesI’m declining this suggestion as we already have this option under Format→Commas & parentheses.
-
Features from SSMS ToolsPack
There is a tool called SSMS ToolsPack (http://www.ssmstoolspack.com) which contains a number of useful tools, such as color-coding windows (which is now an experimental feature in SQLPrompt, but the other set allows you to choose your colors). One of the tools I use with unfortunate frequency (and has saved my bacon numerous times) is their "Query Execution History" feature; this saves every single query you execute with connection information, date/time stamp, and what file name it was executed from. If you've ever had to go "What was that ad-hoc query I wrote but didn't save?" this feature can…
39 votesThanks for your suggestions.
If there are specific features you would like to see added to Prompt, could you please raise individual requests for them? For instance, here is one for “Query Execution History”:
https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/3477515-query-execution-history
Thanks,
The Prompt Team
-
Allow Data Explorer to export data
It would be really great if you were able to export the data to file, or document, spreadsheet. Almost a way to obtain sample data
2 votesI’m going to close this feature request as we have removed the data explorer feature from Prompt.
-
Auto Generate Script for Update
When Typing
UPDATE MyTable and then press TAB
it would be nice when SQL Prompt would generate
UPDATE MyTabLE SEt
MyField1 = @MyField1,
MyField2 = @MyField 2
etc6 votesSQL Prompt has support for auto-completing INSERT statements which as of version 9.3, can be automatically refactored into an UPDATE statement, which should achieve a similar result to what has been requested.
Kind Regards,
The Prompt Team
-
compare
It would be nice to compare 2 objects (tables / stored proc ets), by right clicking on them and select to compare (lig scema compare).
I am using to to clean up an old DB with a lot of copyed code and tables.
7 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Feature request: Remove "AS" clauses from Group By lines...
I use many "as" clauses in my selects. If I need to use a Group By clause, I can copy my Select items, but then I have to manually remove all of the "AS" clauses. It would be a dream to have them removed during a format!
Also, what would be involved in having a "change to other favorite connection" mechanism, so I can switch my current query between production, development and test? And it would be doubly sweet if the switch also changed to my usual db on that instance. Like an Alt-Tab allows you to switch between open…
5 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Allow starting with FROM clause first to make intellisense and query building more natural
Allow starting a query with the FROM clause (ala LINQ) and provide intellisense normally. I would continue normally, right up to the point the user types the select update or delete keywords, at which point you either automagically reposition the keword and cursor to the top of the query, or allow the user to finish and then prompt for query restructuring. This would completely do away with the mucking around of doing a ssf and then going back later to fill in the list! In fact, I'd take it a step further and offer to restructure poorly written queries..e.g., If…
8 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Allow SQL Prompt to work with SQL CE when in Visual Studio
I have been using SQL Prompt with SQL Server for quite a while and have gotten use to the features. I now work with SQL Server CE within Visual Studio and don't get to take advantage of the SQL Prompt features. It would be nice if SQL Prompt worked in the SQL editor in Visual Studio when using sqlce files.
3 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
- Don't see your idea?