270 results found
-
Give the option to disable Microsoft Help suggestions.
I have never clicked on a suggestion that results in opening the Microsoft Help window on purpose.
As an example, if I have a long "IsNull" that takes up multiple lines, a tip box will pop up blocking portions of the query, and no matter where I click, this will pop up and block different portions. Often I will accidentally click the box as I need the cursor to be where the box is, and it will cause the dev environment to become unresponsive while the "Help" window loads.
1 voteHi Danny,
It’s already possible to disable these tooltips in SQL Prompt. If you open up the SQL Prompt options, on the first page it’s under “Show tooltips for: Parameters”.
Thanks,
Aaron. -
VALUES
Correctly qualify the Table Value Constructor.
I frequently use a TVC to find the Max value among several values on a single row, as with the following:
;WITH MyCte AS (SELECT 1 AS a, 2 AS b, 3 AS c)
SELECT
MyCte.a,
MyCte.b,
MyCte.c,
HighestNumber = (SELECT MAX(Value.Val) FROM (VALUES (MyCte.a), (MyCte.b), (MyCte.c)) AS Value(Val))
FROM MyCteWhen I qualify object names within that script, it incorrectly tries to add the 'Value' as a qualifier within the constructor:
…;WITH MyCte AS (SELECT 1 AS a, 2 AS b, 3 AS c) SELECT MyCte.a, MyCte.b, MyCte.c, HighestNumber = (SELECT MAX(Value.Val) FROM1 voteThanks for letting us know about this issue. It should now be fixed in the latest build of SQL Prompt (7.1.0.314)
-
Stop aliasing scientific notation
SQLPrompt will take scientific notation, and alias it as 1[e1], 1[e2] and so on.
1e1
1e2
1e3
1e4
1e5
1e6
1e7
1e8
1e91 voteHi Erik,
Thanks for letting us know about this issue. It should now be fixed in the latest build of SQL Prompt (7.1.0.314)
-
Exclude a region from formatting
Sometimes, formatting makes a query less readable, e.g.
insert table (col1, col2, col3, ....)
values (1,2,3,...),
(11,12,13,...),
...Formatting will put the values on multiple lines if there are enough of them. It's easier to see the data when they are on one line. So how about:
--#region [optional description] #SQLPromptIgnore
--anything in here doesn't get formatted
--#endregion [optional description]Not sure what would be best for '#SQLPromptIgnore'
2 votesAs Joe Momberg said, this is now available in 7.3 – http://documentation.red-gate.com/display/SP7/SQL+Prompt+7.3+release+notes#SQLPrompt7.3releasenotes-Disableformattingforblocksofcode
You can download the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Add the option to replace NULL values for strings as empty strings when using 'Open in Excel'
When using the new feature 'Open in Excel' (the results from the grid), it'd be handy to have an option to replace NULL string values with empty strings ''. Sure you could do ISNULL on all the columns that are a string data type, but it'd be handy to just have the option to have the 'Open in Excel' feature do it.
The only way I've found to quickly do it is to export the data as a csv and use a powershell script with something like:
Export-CSV -NoTypeInformation -Encoding "Unicode" -Delimiter "," $AttachmentPath
(Get-Content $AttachmentPath) -replace "`0", "" |…8 votesSQL Prompt 7.2 now exports NULL values as empty cells when using Open in Excel. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/
-
formatting stored proc
I love to have the options so that the first line of a stored proc is just the name i.e. create proc spName and the @parms varchar(20) and following would be on additional lines
So for examplecreate proc spName
@Parm1 int
,@Parm2 intthanks
Shannon4 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 -
insert
when doing the auto complete on inserts give us an option to just fill in the column names like:
insert into table(col, col, col)
and nothing else - this is how I want 99% of the inserts that I write
1 voteThis is now included in the stable release of SQL Prompt 7.2. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Turn a stored procedure into a script (for testing)
When testing stored procs it's sometimes (or often) required to get the inside of the sproc and test it as a plain script. It would be helpful if SQL Prompt had an option to click a sproc and enable the coder to script it as a script with the input variables declared as plain variables at the head of the script (with maybe default values filled in already). It's something similar to taking script code and making it into a sproc but... the other way round :) It would make life easier for many a dev... Thanks!
27 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 -
Format SQL - quick styles
I want to switch between TEAM and PERSONAL styles for Format SQL. It currently takes 8 mouse clicks to achieve this. Could you add a style lookup on the context menu or Red Gate tools menu and apply the style to the current document automatically as soon as it is selected.
I want my team to be able to work in their personal SQL format, but always save in the TEAM format.
9 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!
-
Search for Snippet Manager
I have a lot of snippets. It would be great to have a search feature to find the snippet I'm looking for to edit it or see that I have it.
6 votesWe’re happy to announce that this feature is now included in SQL Prompt 9.1.3.4467. For additional information see: http://documentation.red-gate.com/display/SP9/SQL+Prompt+9.1+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!
Kind regards,
The Prompt Team
-
Highlight variables having the same name...
This feature would be great... http://stackoverflow.com/questions/21899826/sql-server-management-studio-highlight-variables
2 votesWe’ve added the “Highlight matching objects” experimental feature in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Remove line breaks in selected code
If I select some code I can press Ctrl to open a small menu where I can e.g. "Apply comma" or "Encapsulate as procedure" etc.
It would be nice to have a function to
- remove line breaks
- and / or replace line breaks with comma plus space
- and / or encapsulate as IN conditionUsage:
Copy some Id's from a result set that you want to use in a IN conditionExample:
45486
31321
31167
30985
30844
30818
33989should be "formated" to
45486, 31321, 31167, 30985, 30844, 30818, 339891 voteHi Thomas,
We’ve got “unformat” in the actions list which’ll remove all the line breaks in the current selection.
Apologies if unformat wasn’t an obvious action for removing line breaks – we had 3 UserVoice requests asking for it that had all used the term so it seemed like a good name to use.
-
Introduce the $CLIPBOARD$ placeholder
I would love to see the $CLIPOARD$ placeholder, representing the current text contents of the system clipboard (if there is any text in it, obviously).
1 voteHi,
SQL Prompt 7 already has this functionality via the $PASTE$ placeholder.
You can find the documentation here: http://documentation.red-gate.com/display/SP7/Managing+snippets#Managingsnippets-Defaultplaceholders
-
Add "closed tabs" to the tab history
Add a "closed tabs" list to the tab history - that's usually what I use it for rather than open tabs, which I try to keep to a minimum. That said it makes it hard when there are a dozen tabs all called "SQLQuery1", "SQLQuery2" to know which are open and which are closed...
3 votesThis is included in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Allow the option for SQL formatting of nested inner join on an outer join to indent the nested inner join.
When you have a nested inner join to an outer join, such as:
SELECT a., b., c.*
FROM
A a
LEFT JOIN B b
INNER JOIN C c on b.bid = c.bid
ON a.aid = b.aidIt should allow an option to indent the nested join further to show that it is nested
5 votesWe’ve released support for indenting nested joins in version 8 of SQL Prompt as part of our 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
-
Don't indent BEGIN/END bloc after AS in function/procedure definition
CREATE FUNCTION MyFunc()
RETURNS INT
AS
BEGIN
----IF 1=1
--------BEGIN
------------<some code>
--------END
END
END1 voteThis should already be an option in SQL Prompt under Format→Schema statements→Indent contents.
-
$ISODATE$ placeholder in snippets
The $DATE$ placeholder is great, but it inserts a date string according to my (or the server's?) locale.
I would very much prefer a placeholder that always inserts the current date according to ISO 8601 (e.g. '2015-07-22').1 voteHi Bruno,
In the latest version of Prompt you can pass in a .NET style format string (http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx) to the date placeholder eg. for the date you’ve given you could use ‘$DATE\(yyyy-MM-dd\)$’.
If you have any questions please let me know.
-
Command Line "Reformat All Files In Folder" and pre-Commit
Opening over 2500 code objects to set a baseline format, required by a large customer, is a daunting manual task.
Many of Red Gate's tools provide command-line functionality.
Please add it to Prompt so we can bulk (re)format SPs, UDFs, Triggers. Integration into the commit-path (we use SVN) would be ideal for standardized check-ins (Commits).
Can't recall whether a style is exportable... (License key awaited at new employer) Should be able to point to UNC location for the style to use.
109 votesBulk operations for formatting and code analysis were added as part of SQL Prompt 10.7
-
Generate Scripts Based on the Result Grid
Just like in Toad and SSMSBoost, there's a facility to create a script such as INSERT based from the given result grid. This would be handy in generating test data or re-populating tables
37 votesThis is included in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
try snippet
It would be nice to have a TRY CATCH snippet.
1 voteThis 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?