274 results found
-
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/
-
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 -
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/
-
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/
-
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/
-
Delay before Suggestion dropdown [Bring it back]
I used to have a couple hundred milliseconds of delay in here. This was really helpful in some circumstances to allow me to do down a line of text adding tabs, spaces, commas, etc. (all kinds of things to satisfy my obsessive need for proper formatting). Without this option I now have to hit [ESC] each time to clear the suggestion box no matter how quick I move down, making this an annoyance.
6 votesThis is included in SQL Prompt 6.3, which can be downloaded 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 -
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/
-
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/
-
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.
-
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/
-
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.
-
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.
-
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
-
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 -
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
-
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 -
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.
-
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?