276 results found
-
"d" in "order by" should prompt with "desc", not "dbcc"
Currently if you type a query like this:
select *
from sys.objects o
order by o.name d[CURSOR]the popup consists of dbcc, deallocate, declare, delete, deny, desc, disable trigger, drop, dump.
While that is probably technically accurate, it would be much more helpful to make "desc" the first entry in the list, because it's what I'm typing 100% of the time.
1 voteThis is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Remove extra space between statements option is Needed
SELECT
*
FROM
Temp1--Remove this kind of extra spacing between statements option is NeededSELECT
*
FROM
Temp2--Remove this kind of extra spacing between statements option is NeededSELECT
*
FROM
Temp310 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!
-
Remove Red Gate toolbar
This is an old problem that just won't go away.
The Red Gate toolbar that holds the SQL Prompt icons (Tab History, Add-ins, SQL Test, SQL Search) will not persist it's state in SSMS. You can move it, but it comes back to the same place on it's own row. You can delete it, but it comes back again.
Recommend (a) making the toolbar's state persistent in SSMS and (b) added a feature to the Options menu that allows the user to remove it.
Using SQL Prompt 6.4.0.678 on SSMS 11.0.5058.0 (2012).
6 votesHi all,
Thanks for your help tracking this down! I’ve made a fix for the permission issue here:
http://download.red-gate.com/EAP/SSMSIntegrationPackFramework/SSMSIntegrationPackFramework_1.0.31.0.exe
Which should work without having to run as an administrator. We’ll look into getting this included in the SQL Search and Developer Bundle installers.Thanks,
Aaron. -
highlight all columns and filters for a table alias when that alias is selected
when selecting a particular table alias, can you highlight all places where that alias is being used like in notepad++
5 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/
-
Add 'N' to unicode type literal strings
Hi,
Is it possible to format below code
DECLARE @a VARCHAR(200);
SELECT @a = 'asdf';
DECLARE @b NVARCHAR(200);
SELECT @b = 'asdf';to
DECLARE @a VARCHAR(200);
SELECT @a = 'asdf';
DECLARE @b NVARCHAR(200);
SELECT @b = N'asdf';Thanks.
16 votesHello,
We have added this feature in SQL Prompt 9.1.4.4532
It can be found under Prompt → Options → StyleIt currently only works with variable assignments for variables declared in the same script.
If you would like to see us expand this more please let us know by creating a new idea.
Kind Regards,
The Prompt Team -
Auto complete/intellisense suggestions using PIVOT
Using PIVOT the wrong alias is suggested in the intellisense window as it is the alias from the FROM clause, not the PIVOT clause that is displayed.
The same goes for the auto complete, where field names is (automatically) prefixed with the wrong alias (I know this feature can be disabled...)
Ex:[code]CREATE TABLE dbo.tbTest(
Id INT,
foo VARCHAR(3),
bar FLOAT
)
GO
INSERT INTO dbo.tbTest
VALUES (1, 'foo', 2)
, (2, 'bar', 3)
, (3, 'foo', 4)
GO
SELECT *
FROM (
SELECT *
FROM dbo.tbTest AS tt
) pvt
PIVOT (
MAX(bar) FOR foo IN ([foo], [bar])
)p
[/code]…3 votesThis is included in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Add Comment Block to Surround With choices
Can you add a comment block /* */ to the Surround With choices? It would be of great use.
I also like the idea of adding Surround With options to the snippet editor where one could specify the before and after.
The example one person gave was Surround With ISNull( <highlighted column> ,0)
9 votesSQL Prompt 7 includes a $SELECTEDTEXT$ snippet placeholder which allows you to create surround with snippets that can be used through the Actions List (it also has a comment feature that’ll add — to the start of every line). You can download the latest build from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Let cursor jump to capitalized letters within words (CTRL+arrow)
Hi there. Would it be possible to program a feature that is
present in Visual Studio (I think ReSharper brings it
into VS) which enables a programmer to select/move among
parts of a word based on where the capital letters are? (CTRL+arrow)
Say you have a variable called @ThisIsMyVariable.
If you place the cursor at the end of the word and then
press CTRL+<Left Arrow>, then it’d be nice if the cursor
jumped to the beginnig of the next capital letter instead
of the next word as is usual. This feature is very helpful in VS and I think it’d…2 votesThe latest version of Prompt has an experimental feature for “Change keyboard shortcut behavior for CamelCase words”
-
Warning on delete and update statements if no WHERE clause is specified
It would be nice to get a warning on delete or update statements if you did not specify a where clause.
23 votesSQL Prompt 7.2 displays execution warnings before executing DELETE or UPDATE statements without a WHERE clause. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Tab History (aka SQL Tab Magic) should not show currently open windows
I love Tab Magic (or Tab History), but the with the latest version it also shows the tabs that are currently open. I would like an option to ignore currently open tabs. I can search those tabs right in SSMS, I need Tab History just for ones I've already closed.
2 votesWe’ve added a “closed tabs” option in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Tab Coloring
Had this discussion with some folks at work today. SSMS Toolspack does tab coloring but it places a color band across the entire width of the query editor while SQL Prompt's tab coloring only colors the tab. The whole line is a much more obvious reminder. Be great if SQL Prompt did a similar thing. I realize Tab coloring is an experimental feature still.
4 votesSQL Prompt 7 colors the status strip which covers the entire width of the editor. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Insert Statement Highlighting with Split-Screen
Excellent work by the team in SQL Prompt 6.4 implementing the "Insert Statement Highlighting Column and Value" feature.
It would be great if this could be tweaked to work with split-screen editing. For example, if you have a REAAALLLY wide table, you might want to have your editing cursor in the bottom pane of SSMS but be looking at the top pane.
To clarify, I am talking about allowing the highlighting to work in both the top and bottom panes if you enable Window... Split (or drag the thing down at the top of the scroll bar).
This new…
1 voteWe’ve just release 6.4.0.657 which should have the highlighting on both panes of the split window. You can get the latest build either from Check for Updates inside Prompt or from our website: http://www.red-gate.com/products/sql-development/sql-prompt/
-
Qualify Ojects in SQL (Add square brackets)
When formatting SQL, add an option to force all possible columns/objects/whatever to be qualified with square brackets. So:
CREATE TABLE #qqqqq (aaaaa INT,bbbbb INT,ccccc VARCHAR(5));
Becomes: CREATE TABLE [#qqqqq] ([aaaaa] INT,[bbbbb] INT,[ccccc] VARCHAR(5));
Or: CREATE TABLE [#qqqqq] ([aaaaa] [INT],[bbbbb] [INT],[ccccc] [VARCHAR](5));3 votesThis is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Allow Alias Names to Conflict with Stored Procedure Names
We have a table called SalesOrder. We also have stored procedures named so, so2, and so3. When SQL prompt creates the auto alias, it uses so4 because it won't create an alias using the name of an existing object.
I would like the alias to use so. The aliases don't need to have unique names in cases where the name conflicts with the name of a stored procedure.
If that's not possible or likely, then I would like SQL Prompt to use the custom alias defined for the table, even in cases where the name conflicts with a stored procedure.
1 voteThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
qualify column names with table: temporary tables
The qualify column names should work with temporary tables as well.
2 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Add connection limit for restoring tabs
Please add an option to ignore tabs over a certain number of connections.
It would avoid long waits when SSMS starts if in the previous session I forget to close a one-time query against hundreds of servers.
In its current implementation, SQL Prompt can crash SSMS before the connections complete.
See SQL Prompt forum for context:
http://www.red-gate.com/MessageBoard/viewtopic.php?p=718343 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
1 vote
-
Retrieve BETA Updates when checking for updates
I usually run the latest version of the beta and it would be nice if "Check for Updates" would pick up the latest version version of SQL Prompt, including any beta versions.
Perhaps this could be an option for those that aren't interested in participating in betas.3 votesSQL Prompt 7 now has a button to toggle beta updates on the check for updates dialog.
-
Remove trailing spaces
Option to remove trailing spaces from script lines. This can be done via search/replace functionality but it would be nice to have this taken care of automatically during the SQL code reformatting
7 votesVersion 8 of SQL Prompt allows you to do this as part of its 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
-
Autogen insert and commas at the beginning of the statement
I find having the commas at the beginning of the line extremely useful - and was glad that Sql Prompt allows us to set the default as such for insert statements. I have to say the format is quite difficult to read, and find that I have to rewrite it each time. Can you please spend a few minutes to clean it up? I see there are a couple outstanding requests that have been ignored for 2 years now - no input from redgate at all. I'm sure there are others who would agree with this - (just check out…
2 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
- Don't see your idea?