270 results found
-
Add Comment Block to Surround With choices
Can you add a comment block /* */ to the Surround With choices? It would be of great use.
I also like the idea of adding Surround With options to the snippet editor where one could specify the before and after.
The example one person gave was Surround With ISNull( <highlighted column> ,0)
9 votesSQL Prompt 7 includes a $SELECTEDTEXT$ snippet placeholder which allows you to create surround with snippets that can be used through the Actions List (it also has a comment feature that’ll add — to the start of every line). You can download the latest build from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Let cursor jump to capitalized letters within words (CTRL+arrow)
Hi there. Would it be possible to program a feature that is
present in Visual Studio (I think ReSharper brings it
into VS) which enables a programmer to select/move among
parts of a word based on where the capital letters are? (CTRL+arrow)
Say you have a variable called @ThisIsMyVariable.
If you place the cursor at the end of the word and then
press CTRL+<Left Arrow>, then it’d be nice if the cursor
jumped to the beginnig of the next capital letter instead
of the next word as is usual. This feature is very helpful in VS and I think it’d…2 votesThe latest version of Prompt has an experimental feature for “Change keyboard shortcut behavior for CamelCase words”
-
Warning on delete and update statements if no WHERE clause is specified
It would be nice to get a warning on delete or update statements if you did not specify a where clause.
23 votesSQL Prompt 7.2 displays execution warnings before executing DELETE or UPDATE statements without a WHERE clause. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Tab History (aka SQL Tab Magic) should not show currently open windows
I love Tab Magic (or Tab History), but the with the latest version it also shows the tabs that are currently open. I would like an option to ignore currently open tabs. I can search those tabs right in SSMS, I need Tab History just for ones I've already closed.
2 votesWe’ve added a “closed tabs” option in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Tab Coloring
Had this discussion with some folks at work today. SSMS Toolspack does tab coloring but it places a color band across the entire width of the query editor while SQL Prompt's tab coloring only colors the tab. The whole line is a much more obvious reminder. Be great if SQL Prompt did a similar thing. I realize Tab coloring is an experimental feature still.
4 votesSQL Prompt 7 colors the status strip which covers the entire width of the editor. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Insert Statement Highlighting with Split-Screen
Excellent work by the team in SQL Prompt 6.4 implementing the "Insert Statement Highlighting Column and Value" feature.
It would be great if this could be tweaked to work with split-screen editing. For example, if you have a REAAALLLY wide table, you might want to have your editing cursor in the bottom pane of SSMS but be looking at the top pane.
To clarify, I am talking about allowing the highlighting to work in both the top and bottom panes if you enable Window... Split (or drag the thing down at the top of the scroll bar).
This new…
1 voteWe’ve just release 6.4.0.657 which should have the highlighting on both panes of the split window. You can get the latest build either from Check for Updates inside Prompt or from our website: http://www.red-gate.com/products/sql-development/sql-prompt/
-
Qualify Ojects in SQL (Add square brackets)
When formatting SQL, add an option to force all possible columns/objects/whatever to be qualified with square brackets. So:
CREATE TABLE #qqqqq (aaaaa INT,bbbbb INT,ccccc VARCHAR(5));
Becomes: CREATE TABLE [#qqqqq] ([aaaaa] INT,[bbbbb] INT,[ccccc] VARCHAR(5));
Or: CREATE TABLE [#qqqqq] ([aaaaa] [INT],[bbbbb] [INT],[ccccc] [VARCHAR](5));3 votesThis is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Allow Alias Names to Conflict with Stored Procedure Names
We have a table called SalesOrder. We also have stored procedures named so, so2, and so3. When SQL prompt creates the auto alias, it uses so4 because it won't create an alias using the name of an existing object.
I would like the alias to use so. The aliases don't need to have unique names in cases where the name conflicts with the name of a stored procedure.
If that's not possible or likely, then I would like SQL Prompt to use the custom alias defined for the table, even in cases where the name conflicts with a stored procedure.
1 voteThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
qualify column names with table: temporary tables
The qualify column names should work with temporary tables as well.
2 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Add connection limit for restoring tabs
Please add an option to ignore tabs over a certain number of connections.
It would avoid long waits when SSMS starts if in the previous session I forget to close a one-time query against hundreds of servers.
In its current implementation, SQL Prompt can crash SSMS before the connections complete.
See SQL Prompt forum for context:
http://www.red-gate.com/MessageBoard/viewtopic.php?p=718343 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
1 vote
-
Retrieve BETA Updates when checking for updates
I usually run the latest version of the beta and it would be nice if "Check for Updates" would pick up the latest version version of SQL Prompt, including any beta versions.
Perhaps this could be an option for those that aren't interested in participating in betas.3 votesSQL Prompt 7 now has a button to toggle beta updates on the check for updates dialog.
-
Remove trailing spaces
Option to remove trailing spaces from script lines. This can be done via search/replace functionality but it would be nice to have this taken care of automatically during the SQL code reformatting
7 votesVersion 8 of SQL Prompt allows you to do this as part of its 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
-
Autogen insert and commas at the beginning of the statement
I find having the commas at the beginning of the line extremely useful - and was glad that Sql Prompt allows us to set the default as such for insert statements. I have to say the format is quite difficult to read, and find that I have to rewrite it each time. Can you please spend a few minutes to clean it up? I see there are a couple outstanding requests that have been ignored for 2 years now - no input from redgate at all. I'm sure there are others who would agree with this - (just check out…
2 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Give Format SQL the ability to convert X.Field1 AS NewFieldName format to FieldName = X.Field1
We have a lot of legacy code that is written as
SELECT Field1 as Name1, Field2 Name2 FROM Table X
(Sometimes they use AS when setting the alias, othertimes they do not).I would love the ability to convert this to
SELECT
Name1 = X.Field1
, Name2 = X.Field2
FROM Table XBoth having the ability to switch between Name = Value and Value AS Name and to auto add the alias to all fields.
9 votesThis feature was released in version 7.3 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team -
Dot insertion key breaks IP addresses in Linked Servers
I added the 'dot' option to insertion keys and now I am unable to type dots in an IP address for a linked server without it autocompleting some random address, which I then have to go back and correct.
1 voteThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
sort
It would be nice to have sortable columns in the table popup. This way we can see them in ordinal order (as it exists now), or order them alphabetically (or even by data type). Hopefully not much harder than changing a grid column property.
This would make it much easier for our Oracle folks to accept using SSMS, as it seems all Oracle tools do this by default. It would also shut them up. :) :)1 voteThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Add ParserLookBackDistance and ParserLookAheadDistance values to the Options menu
Due to the length of some of the queries I write, I have to edit the file RedGateSqlPromptEngine_EngineOptions.xml manually. It would be nice to be able to edit the values for ParserLookBackDistance and ParserLookAheadDistance in the Options menu. I understand the drawbacks of making these values too large. If they were in the Options menu I could adjust them for a long query and then set them back for shorter queries.
3 votesThese options have been superseded with a new system in SQL Prompt 6.4, 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/
-
Allow me to specify schemas to include or exclude
The options to "Only load suggestions for certain databases" and "Don;t load suggestions for certain databases" are nice, but it'd be really useful to also be able to include or exclude on a per schema basis.
34 votesWe added schema filtering in SQLPrompt 9.4.15. You can learn more about the feature here: https://documentation.red-gate.com/sp9/managing-sql-prompt-behavior/managing-connections-and-memory
We would love to hear your feedback.
- Don't see your idea?