276 results found
-
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 -
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.
-
Don't alias objects with reserved words
CREATE TABLE dbo.GrumpyOld (col1 int)
SQL Prompt will alias the table as GO, which causes problems because it's a batch separator.
Thanks!
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 -
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. -
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.
-
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) FROM
1 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)
-
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/
-
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
-
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.
-
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/
-
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 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
-
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 -
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 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/
- Don't see your idea?