78 results found
-
keep getting Sql server management studio IsBusy, because of sql prompt
sometimes its counter productive, messing up in the way of regular intellisense
1 voteHi Anvoy,
Sorry to hear you’re having issues with SQL Prompt! This sounds more like a bug than a feature request so I’m going to close this idea – our support site would be a better place to log it: https://redgatesupport.zendesk.com/hc/en-us/requests/new
please include the version of SQL Prompt that you’re using and detailed recreation steps.Thanks,
Aaron. -
Tab Colouring, Naming and Grouping - Job Specific
Query Tab Colouring: To be able to have more than one colour of Tab per Database. I am often working on more than one Job at a time that are using the one Database.
Query Tab Grouping: to be able to group a set of tabs together, so I can minimize all tabs in that group to one 'Group Tab' to expand later. Also, when finished that task I can easily close the Group of Tabs.
Query Tab Naming: to be able to give the Tab a name without saving the query.
4 votesI’m going to close this request as it’s 3 features in 1, which means it’s going to be difficult for us to prioritise and begin work on.
It’s also duplicating two existing feature requests:
https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/6913823-tab-groups
https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/6681088-rename-open-tabsClosing this request should return your votes so please do add your votes to these two.
-
SQL Refactoring similar to what JetBrains do for C#
Would it be possible to peek at what JetBrains do for C# and implement similar functionality in T-SQL? It doesn't have to be as sophisticated as JetBrain's... Just a suggestion of mine. I bet you could certainly find good cases where refactorings like JB's would come in useful. Very, very useful. Thanks!
1 voteHi Darek,
I’m going to decline this idea as it’s unclear what the actual feature is. You should have your UserVoice votes returned to you so if you have a specific refactoring feature that you’d like to see in SQL Prompt please do post it as a new idea.
-
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.
-
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
-
Sort Selected Text
Sorts selected lines. Nothing fancy, but incredibly useful.
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
-
subqueries - start on new line
I'd like an option under data statements --> Subqueries to be able to drop sub-queries starting on a new line like in section Schema Statements --> New lines.
Example:
SELECT
[pgp].[patientid]
FROM
[dbo].[PTGEPATIENT] AS pgp
WHERE
[PATIENTID] NOT IN (SELECT
patientid
FROM
[dbo].[PTAPALCOHOL] AS paa)would become
SELECT
[pgp].[patientid]
FROM
[dbo].[PTGEPATIENT] AS pgp
WHERE
[PATIENTID] NOT IN (
SELECT
patientid
FROM
[dbo].[PTAPALCOHOL] AS paa
)5 votesWe’ve released a new formatting engine in SQLPrompt Version 8.
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
-
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 -
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. -
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.
-
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 -
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
-
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 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.
-
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
-
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.
-
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
-
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
- Don't see your idea?