276 results found
-
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.
-
Stop deleting parenthesis I type
If I edit a statement like SELECT COALESCE(x, y, z) and then add some parenthetical as in LTRIM(COALESCE(x, y, z)), the last parenthetical is deleted by SQL Prompt even though I typed it. Two options are to 1) correctly establish parenthesis or 2) stop deleting characters I type correctly
12 votesThis is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Snippet Manager - Placeholder For New GUID
It would be nice to have a placeholder that, when the snippet was used, was replaced with a new GUID. For example:
INSERT audit.Changes (Id, Date, Reason)
VALUES ('$GUID$', '$DATE$', '$CURSOR$')2 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Highlight --TODO and --HACK comments
When a --#TODO: or --#HACK is written on our code, it could be helpful to highlight it in order to give an alert to the reader. In addition it can be very helpful to let the user to configure the pattern (i.e. --#MyTerm).
46 votesWe’ve released support for highlighting TODOs in version 9 of SQL Prompt as part of its new code analysis feature.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
We’re marking this request as completed, but if you feel strongly about being able to configure the term, please feel free to open a new suggestion.
Kind regards,
The Prompt Team
-
Formatting SQL Transaction
It would be nice to have the code within a BEGIN TRAN and COMMIT be indented.
BEGIN TRAN
<ssss>INSERT....
<ssss>UPDATE....
COMMIT TRAN6 votesWe’ve released a brand new formatting system in version 8 of SQL Prompt and have made further improvements since.
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
-
Add brackets to all database objects
Similar to the existing Qualify Object Names and the other pending request to fix case of all object names, I would like to have an option to add brackets added to all database object names (columns, tables, schemas) where they are missing.
13 votesThis is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Search Middle of Snippet name
Intellisense should find snippets where characters appear anywhere in the snippet name, not just at the beginning. I have 2 or 3 dozen snippets and I can't always remember what the less frequently used snippets are called. For example I might several snippets that deal with space usage, but some are named like this: "getSpaceUsage". It would be useful if typing "space" found all snippets that contained space anywhere in the name not just at the beginning.
4 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Format "case" keyword also in uppercase
When formatting a case statement I want the case keyword to show in uppercase just like the when and end keywords. Now initially it uppercases CASE but when running SQL format it turns it to lowercase (bug?) See example below of the current format behaviour.
SELECT case WHEN 1 = 1 THEN 1
ELSE 0
END1 voteThis should be fixed in the latest build of Prompt
-
2014 ctp2 support
please add support for sql 2014 ctp2, i'm already using it and im sure others are as well and quite frankly i've grown very accustomed to using sql prompt that it became quite hard to work without it.
i hope you can add the support really soon
9 votes -
Give more flexibility in SQL Formatting
The SQL formatter was one of the reasons we chose to buy the Developer Toolkit, but it doesn't seem to be able to be configured to format to our company style.
An example of the style is here: http://pastebin.com/LTLRJ6Fb
Notably, it would be good to be able to have the FROM and table name on the same line without excess white-space in between,
7 votesThis feature was released in version 8 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team -
Comments that appear before ALTER statement should be preserved
Currently any comments that appear before the ALTER PROC statement are not scripted by SQL Prompt which results in those comments being silently deleted if the alter statement is executed.
If I hover the mouse over a stored procedure name and click on the procedure name that pops up in order to see the script window I can see these comments but if I type alter proc <procname> and press tab to produce an alter script these comments are missing.
There is a danger here of losing comments without the user being aware of it. I think SQL Prompt should…
8 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Formating create table command
Currently when formatting a Create table command the SQL Prompt is moving the "Default" to a next line and indenting it...
like this
[insertDT] DATETIME NULL
[______INDENT] DEFAULT GETDATE()
,[ActualMU] INT NULL
[___INDENT]DEFAULT 0
,[PlannedMu] INT NULL
[___INDENT]DEFAULT 0
,[CompletedDT] DATETIME NULL
[___INDENT___] DEFAULT GETDATE()And the format that I would like to see (making easier to read) is
keeping all definition of each field in the same line, like,[insertDT] DATETIME NULL DEFAULT GETDATE()
,[ActualMU] INT NULL DEFAULT 0
,[PlannedMu] INT NULL DEFAULT 0
,[CompletedDT] DATETIME NULL DEFAULT…5 votesThis feature was released in version 8 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team -
SQL Prompt tries to retrieve objects from other databases
After upgrading to SQL Prompt 6 (6.1), I notice reduced performance and I occasionally get "SQL Prompt cannot retrieve objects from <some database name>. (etc)", which reference a database that I do not use or am ever likely to use and IIRC have never used. It seems SQL Prompt is trying to cache objects for all databases on the connected server. That would be overkill, and only serves to slow it down and cause errors such as the one mentioned.
3 votesThis was likely due to the synonym support added in 6 which will try to offer suggestions by loading databases that the synonyms are referencing. In the latest build of Prompt this is optional (under Suggestions→Connections) and off by default.
-
Automatically generate the GROUP BY column list from the SELECT list
Typically, the GROUP BY column list is exactly the same as the SELECT list except the aggregates and any constants included. I usually wind up using a copy & paste, which is always a hassle, especially if it is a complex query. It always seemed to me that the GROUP BY list should be optional in the SQL standard. But short of a standard change followed by implementation changes, it would be nice to at least have it defaulted for me.
By the same token, the HAVING statement could (optionally) prepopulate with (one of) the aggregate(s) from the select list.…
25 votesThis is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Incorrect capitalization of system functions
The SQL Prompt formatter incorrectly tries to capitalize (whether automatically while I type or using the formatter) system functions that are missing a database prefix. For example, SQL Prompt doesn't try to capitalize:
sys.fn_listextendedproperty
but it WILL capitalize
fn_listextendedproperty
as soon as I hit space, regardless of the CASE setting in SQL Prompt's options. Obvious, a capitalized FN_LISTEXTENDEDPROPERTY does not work: the function is case-sensitive.
There does not appear to be a way around this, not even by setting Format -> Styles -> Case -> Buit-in functions to "Leave as is". That only resolves the problem for the manual formatter:…
1 voteThis is fixed in the latest build of Prompt, if you’re still having problems please let me know.
- Don't see your idea?