269 results found
-
Apply Tab Colors on any schema-updating tabs too
Currently Tab Colors applies only on the Query tabs. It's much better to
apply on schema-updating tabs too. Tabs such as Table/View designer or even Red-Gate SQL Source Control tab :)1 voteThanks for your suggestion Reza!
We have already implemented this in the latest version of SQL Prompt so if you upgrade then both the table and view designers should have their tabs colored in the same way as queries. If they’re not being colored after upgrading to SQL Prompt 7.2 then you may have hit a bug so please do let me know.
-
format is now deleting extra lines after the query
Looks like version 7.3 of SQLPrompt removes all blank lines after the query that it formats. Please change this back or make it optional to delete blank lines at the bottom of the query.
1 voteWe’ve just shipped a new beta build (7.3.0.619) that will preserve the extra lines at the end of the query if “Preserve existing new lines between statements” is checked.
You can download the latest beta build from https://forums.red-gate.com/viewtopic.php?f=169&t=79994
-
Enhancement to "Warning on delete and update statements if no WHERE clause is specified" (clarified)
This is a clarification to an earlier post. (https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/13543761-enhancement-to-warning-on-delete-and-update-state)
This is a great idea, but I was surprised by the number of "false positives" I am getting (and yes, I can just mute the messages completely).
In my case I am doing a lot of updates/deletes on permanent tables with joins to temporary tables or table variables and that limits the update/delete scope.
Can you add to this feature so that messages will not be emitted if there is a join to a temporary table or table variable?
For example...
Update dbo.RealTable
Set SomeData = tt.SomeData
From dbo.RealTable…6 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 -
Option to remove gutter menu
Please provide a way to turn off the gutter icon. I do not use it but what DOES happen is that I constantly activate it when I'm selecting and moving around in my sql. It's annoying - extremely.
1 voteHi Nick,
This should already be possible in the latest version of SQL Prompt (7.2.4), you can right click on the icon in the gutter and select “Disable actions list”. Alternatively there’s a check box in the SQL Prompt options on the behavior page for “Show actions list for selected test” and unchecking this should also disable the feature. If you have any problems with it still appearing after you’ve disabled it just let me know.
Thanks,
Aaron. -
Configurable Execution Warnings
The new Execution Warnings functionality to warn of UPDATE or DELETE statements without a WHERE clause is great; however, the warning triggers even when the code is in the definition of a Stored Procedure.
It would be good then to have advanced functionality to allow for us to be able to select whether to warn on SP definition text, or to turn on the warnings when running against temporary tables.
3 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 -
DBCC SHOW_STATISTICS('...','...) WITH DENSITY_VECTOR
Hi!
It would be nice to have an IntelliSense for the DBCC SHOW_STATISTICS command.
When typing
DBCC SHOWSTATISTICS('HashAggregation','WASys00000001_2A8B4280')
it would be helpfull to get the option of "WITH DENSITY_VECTOR" for example.
1 voteThis 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 -
deleting snippets with d
It would be nice if pressing the "d" key did NOT delete a snippet in the Snippet Manager!
It took me two key strokes to figure out why the program didn't went to the first snippet beginning with a "d" - and now I have to spend time figure out what I have been deleting!!
Of course, being able to navigate the long list of snippets using only the keyboard would be nice too. But of less importance. Deleting stuff without warning is bad, though!
1 voteThis 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 -
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 -
Enhancement to "Warning on delete and update statements if no WHERE clause is specified"
This is a great idea, but I was surprised by the number of "false positives" I am getting (and yes, I can just mute the messages completely).
In my case I am doing a lot of updates/deletes with joins to temporary tables or table variables and that limits the update/delete scope.
Can you add to this feature so that messages will not be emitted if there is a join to a temporary table or table variable?
2 votesThanks for your feedback on this feature! We’ve just released a new build of SQL Prompt (7.2.1) which won’t show these warnings when modifying temp tables with aliases.
-
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. -
suggestion box is sometimes in the way
The intellisense box often obscures data in the grid results payne which requires that I hit esc to close suggestions and then retype or ctrl-space to bring it back up.
Possible solutions:
1) The main reason is that the box is usually much larger than it needs to be. If it would auto size as needed it would take up much less room.
2) an optional transparency setting would be much appreciated. Initially draw the box opaque but when the user stops typing, start fading it out a bit slowly because the user may want to see content below. The…
21 votesTransparency was added as an option in SQL Prompt 9.4.10.
-
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/
-
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 -
Change Filename add NEWNAME
ALTER DATABASE <DB Name>
MODIFY FILE (NAME = '', NEWNAME = '')1 voteHi Lee,
Thanks for letting us know about this. NEWNAME is now suggested in SQL Prompt 7.2 which you can download from our website or through Check for Updates in the SQL Prompt menu.
-
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!
-
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)
-
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/
-
4 votes
We’ve released support for static code analysis mentioned in the comments in version 9 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
-
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
- Don't see your idea?