269 results found
-
Case formatting
Case formatting to allow option of capitalising initial letter only - e.g. Select, not SELECT or select.
1 voteThe latest version of Prompt has the casing option UpperCamelCase which will case SELECT as Select.
-
Enable "reconnect to server" on SSMS startup
Reopening tabs is a great feature. HOWEVER, to have all the tabs sit there saying "not connected" means I have to manually reconnect to every one of them. Quel pain! Being in the middle of a time-crunch project with 12 tabs sitting there all disconnected motivated this request...
Please present the Tab Magic overlay and give us:
1. the option to "connect to last connected server with last-used credentials" for selected tabs.
2. the option to choose another server from the list (it's OK if the connect dialog pops up once the overlay is dismissed).
3. the option to remove…3 votes -
Installing SQL Prompt 6 deletes old connection coloring options.
Installing SQL Prompt 6 deletes old connection coloring options.
Please Fix.3 votesSQL Prompt 6.3 will now upgrade the tab colouring options from version 5. SQL Prompt 6.3 can be downloaded from which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
However if SQL Prompt 6 has already run on the machine it will have created a new settings file which won’t be overwritten. To manually upgrade, copy servers.xml from “localappdata\Red Gate\SQL Prompt 5” to “localappdata\Red Gate\Red Gate\SQL Prompt 6”.
-
snippet isn't working correctly
When using snippet with version before 6 (5ish), I could just hit tab and it will give me the correct code. However, with version 6, sometimes (half of the time), the first choice is nothing. It will do nothing rather than giving me the code for that particular snippet. Please fix it. It's very frustrating.
2 votesHi Jay, I think this was fixed a while back but if you’re still encountering any issues with it let us know.
-
Allow Ctrl - > to escape from SQL Prompt so we can move to the next word.
Ctrl - > (right or left arrow key) is the default for move to next word in the editor. In order to escape SQL prompt you can use the left or right arrow, esc etc, but why not include Ctr right arrow or Ctr left arrow so we don't have to type the extra characters. Makes coding with SQL prompt burdensome. Still use it and thanks!
8 votesSQL Prompt 6.2.0.366 doesn’t swallow the Ctrl+Left and Ctrl+Right if the column picker is disabled.
-
Option to unformat onto a single line
Often when I'm debugging code that dynamically generates SQL, I hit a breakpoint, then copy the code into an SSMS query window. All the code is typically in a single long line. I can then use SQLPrompt to format the code to read it, and potentially change it to correct errors. However, what I then often want to do is to paste the changed code back into the variable (or whatever). I'd love to be able to have an option to format the code all into a single line.
6 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Option to align AND predicates with WHERE
Would love to be able to have all predicates at the same indent level ie:
WHERE something = yetsomethingelse
AND somethingelse = anotherthing9 votesWe’ve released support for formatting options such as this in version 8.0 of SQL Prompt.
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
-
Insert Statement Highlighting Column and Value
Assume that I have an INSERT statement such as:
INSERT INTO dbo.MyTable (Column1, Column2, Column3)
VALUES ('Apple','Orange','Grape');If the mouse pointer is in the word 'Apple', the text Column1 should be highlighted in some way. This will help the user clearly see the alignment of which field they are in. If I move my cursor over to 'Orange', the text Column2 should then be highlighted. This is a very simple example, but sometimes I deal with queries with dozens of columns and it's a chore just to find which value in the bottom of the query corresponds to which value…
21 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
What happened to the options settings for Tab Magic? I rarely, if ever, want the last tab opened and would like to be able to stop it
What happened to the options settings for Tab Magic? I rarely, if ever, want the last tab opened and would like to be able to stop it from doing so every time I start an instance of SSMS
2 votesWe’ve released SQL Prompt 6 which includes the tab magic options.
-
Copy button on code popups in 6.0
I really like the new feature in 6 that allows Ctrl-C to work to copy sections of scripts. However, I am missing an easy way to copy the entire script from the code pop-up. The copy button use to do this when nothing was selected in the pop-up window. Restoring this functionality would be appreciated.
8 votesSQL Prompt 6.1 has now been released and has the copy button returned to the popup.
-
More Matching in Intellisense
It would be nice to be able to extend the intellisense matching to skip things like underscores. For example, if the table was called cardpickupstaging, you could match it with pickupstaging or upstag.
4 votesThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Tab Magic EAP hijacks CTRL-T completely.
Do not hijack CTRL-T in Tab Magic. I routinely use this to direct query output to Text. I use this in concert with CTRL-D, for output to Grid.
Perhaps when options for Tab Magic are provided, we will be able to turn off this feature.1 voteWe’ve released SQL Prompt 6 which includes the ability to change the keyboard shortcut.
-
query history starts at Open Queries;
I would like a config open so that the dropdown of queries starts at OPEN QUERIES not all queries
also, I would like it when my mouse hovers over the magic tab button for it to just expand... the extra click makes it less magic
3 votesWe’ve released SQL Prompt 6 which includes this.
-
Better work with temporary tables variables
The script below does not generate the correct sql syntax when adding a @table name into a subselect
DECLARE @temptable AS TABLE (recid INT)
DECLARE @mytable AS TABLE (contractid INT)
INSERT INTO @mytable
( contractid )
VALUES ( 1 -- contractid - int
)---> type @my -> then tab
--> the table is predefined with brackes wich is wrong for a @table
-> the below row is the resultSELECT * FROM @temptable WHERE recid IN (SELECT * FROM [@mytable])
11 votesThis case should be fixed in the latest release of Prompt (6.3). Let me know if you’re still having any problems with it.
-
Show Long file names in Query History in Tool Tip
Hi,
Thanks for your last changes!
In addition, I have sometime Long file names where only looking on their Name tail or according to their full path, I can decide which one is the relevant.
Could you add in Query History a Tool Tip when hovering above the File Name with Full Name, Path, Last Closed, Last Connection details, etc.?THNX
Jermy1 voteWe’ve released SQL Prompt 6 which includes this.
-
Bulk Delete old tabs
It would be great to be able to bulk delete old or unneeded tabs from Tab History. Right now, I have to delete it one by one which is an endless task.
8 votesWe’ve released SQL Prompt 6 which includes this.
-
SQL Tab Magic - When searching query history the text in the preview pane jumps to the left
Hi,
First, I like the new design, and thank you for make it available for SSMS 2012.
I have 2 problems:
1. I missing the Option button (I don't wont it to open recently closed queries on start-up).
2. When I'm searching for term in the Query History dialog, and hovering above one of the files in the left pane, its query text in the preview pane jumps to the somewhere in the file and move a bit to the left. I assumes it suppose to jump to the first match, but, it is not always even in the frame.…3 votesWe’ve released SQL Prompt 6 which includes a fix for these.
-
Recognize double quotes for object names in the same way as square brackets.
Please enable SQL Prompt to have the same behavior with double quotes as with square brackets.
For example, typing:
SELECT * FROM [MyTable]
will allow the expansion of the asterisk, while
SELECT * FROM "MyTable"
does not.SET QUOTED_IDENTIFIER is ON by default. Also, many Oracle "converts" use the format "SchemaName"."TableName".
1 voteThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Unwrap sp_executesql
Frequently I need to debug application generated SQL obtained via Profiler. Parameterized queries are often implemented with sp_executesql.
I love using Format SQL to make a single line monster query into something I can actually read. But when it's stuck in an spexecutesql call the format function doesn't touch it. I have to:
Remove "Exec spexecutesql".
Remove the apostrophes around the query SQL. For big queries this is really painful, especially if the query itself contains apostrophes.
Remove the apostrophes around the parameter defenitions.
Move the parameter definitions to the top and add a DECLARE.
Move the parameter…18 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 -
Unformat SQL
It would great if there was an un-format SQL command, which would basically un-format the SQL by removing all the carriage returns, tabs, extra spaces, etc. I know it seems odd, but we have several applications that use the SQL via external files, so the formatting will not work, and we end up manually removing all the formatting.
7 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
- Don't see your idea?