275 results found
-
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/
-
Support a common intending option for SELECT
Sample query (spaces marked with underscores):
SELECTstaffId, staffName, a
FROM__personnelSELECT and FROM have whitespace after them to align the rest of the statement. This formatting style is tedious to maintain and almost nowhere to be found in real codebases or on the web. Please support the more common code style:
SELECTstaffId, staffName, a
FROMpersonnelJust one space.
41 votesThis feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes
You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for your help!
-
Fix SQL Case Formatting - Consistent Casing
I have been sent a large database schema create script from a legacy system.
The schema has been written in a case insensitive way.
So for example any variables in the stored procs in this create script have been written in multiple cases:
@pvariableNameOne
@pvariablenameOne
@pvariablenameOne
@pVariablenameOne
etc....The database was originally hosted on a Latin1GeneralCIAS Collation at server and database level.
The new hosting environment has been set to Latin1GeneralCSAS at server level, making it case sensitive.
Although we can set the database to Latin1GeneralCI_AS to make…10 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Its a very nice tool who made developer life very easy and do a major and boring task of code formatting by just pressing CTRL+K+Y.
Its a very nice tool who made developer life very easy and do a major and boring task of code formatting by just pressing CTRL+K+Y.
i need a feature who can help developer very much like 1)If there is a SQL Insert query and i select a field it should highlight the value assigned to that selected field because finding this become more painful in formatted code.7 votesSQL Prompt now contains the Highlight Matching Objects feature: https://documentation.red-gate.com/display/SP7/SQL+Prompt+7.1+release+notes#SQLPrompt7.1releasenotes-Highlightmatchingobjects
-
Grant no longer suggests Domain users or groups
When typing a GRANT statement I no longer suggestions after the "TO" for domain users or groups that exist in the database. I only get SQL Users.
Please include all users in "Security\Users" after the "TO" in the GRANT statement intellisense.
4 votesThis is fixed in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Smart alias rename
It would be really nice to have a smart rename for aliases.
Example:select c.ID, c.Name, a.*
from Customers as c
join Adress as a on c.adressid = a.adressidUsage: I select alias "c", click right mouse(or shortcut) and choose Smart Rename and the new aliase should be changed everywhere I use it.
9 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
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.
- Don't see your idea?