269 results found
-
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. -
IF statement format options
Please provide the option to format IF statements as follows, based on the format settings sample.
IF @productType IN ('a', 'b', 'd', 'g', 'i', 'O', 'Q', 'X', 'Z') BEGIN
----IF @cost <= @compareprice BEGIN
--------PRINT 'Less than $' + CAST(@compareprice AS varchar(20))
----END ELSE BEGIN
--------PRINT 'Exceeds $' + CAST(@compareprice AS varchar(20))
----END
END
3 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
-
Aggregate Functions wrongly put in square brackets
I think I 've found a bug...
If you Format this SQLDECLARE @Translations TABLE ( [FundTypeId] INT NOT NULL , [ColumnName] NVARCHAR(128) NULL , [ColumnValue] NVARCHAR(256) NULL , [InsertedAt] DATETIME NULL , [InsertedBy] NVARCHAR(256) NULL , [LastUpdatedAt] DATETIME NULL , [LastUpdatedBy] NVARCHAR(256) NULL , PRIMARY KEY ( [FundTypeId] ) ); SELECT * FROM ( SELECT [pt].[FundTypeId] , [pt].[FundType] , [pt].[Comment] , [pt].[InsertedAt] , [pt].[InsertedBy] , [pt].[LastUpdatedAt] , [pt].[LastUpdatedBy] FROM @Translations AS [tmp] PIVOT ( MAX([ColumnValue]) FOR [tmp].[ColumnName] IN ( [FundType], [Comment] ) ) AS [pt] ) AS [tmp];
... it will break the code as the MAX function of…
1 voteWe’ve just released a new build of Prompt ( 6.5.0.332) which should have a fix for this. You can get the latest version from our website http://www.red-gate.com/products/sql-development/sql-prompt/
-
Add a menu option to decrypt stored procedures
It would be useful to add an option to decrypt encrypted stored procedures and display the decrypted SQL in a query tab.
We often work with encrypted SP's on customer databases, but when there is a bug report, it is often hard to see what is going wrong.1 voteHi Dirk,
This is already available in the latest SQL Prompt. It’s on by default but just to double check it’s enabled for you, there’s a checkbox at the bottom of the behavior page in the options named “Decrypt encrypted objects”.
Thanks,
Aaron. -
Add wildcards to tab coloring
Would be useful if tab coloring supported wildcards
eg *.sql = production
*.dev = development etc1 voteHi Nigel,
Wildcards are already supported for tab coloring in the latest version of Prompt. Just use a * for the wildcard in either the server or database column on the tab color options page. If you’re having any problems with this, please send me an email: aaron.law@red-gate.com
-
Inserting the AS keyword for aliases
It would be nice if one could click a button and get the AS keyword between an object name and its alias. This would help with code that doesn't use AS to separate the two. And would also help readability.
Thanks.
4 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 -
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/
-
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/
-
"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/
-
Better SQLXML Support....
SQL XML is a great tool that gets very little support. When I am on an XML type variable...the intellisense isn't great....AT ALL. Doing something like:
declare @xml XML;
set @xml = '<Tests><Test><Id>1</Id></Test></Tests>';select @xml.value --This doesn't have intellisense. It will try to capitalize .value to .VALUE which isn't correct.
So better SQL XML support would be nice.
1 voteHi Mario,
In your example “value” will be suggested and left as lowercase in the latest version of Prompt 6. If you’re still having problems even on the latest version please contact support as you may have hit a bug.
Thanks,
Aaron. -
RECEIVE statement - Format SQL ignores
;
RECEIVE TOP(1)
@h = conversationhandle,
@t = messagetypename,
@b = messagebody
FROM SimpleQueueTargetFrom the Service Broker Workbench on Simple Talk.
It only moves the semicolon to a separate line. No errors. Ignores "comma at start".
And, yes, the @'s above probably start in column 1, when they're actually in col 5.
1 voteThis 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 -
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 support for SQL CMD variables in SSDT/VisualStudio
When using SQL CMD variables in VisualStudio/SSDT project to support Database references using a Database variable(ex Different database, same server). SQL Prompt is no longer able to resolve objects.
SELECT a.* FROM [$(RefDataBase)].[dbo].[MyTable] a
Then a becomes an "unresolved alias"1 voteThis is included in SQL Prompt 6.5 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/
-
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 -
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
-
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/
-
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/
-
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/
-
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.
- Don't see your idea?