269 results found
-
Rank suggestions by popularity
I would like to suggest a ranking feature when the suggestions list appears. At my place of work, if I want to select out of the customer table I will often type 'cu' then tab the rest. However this is the snippet for creating a user. This is also useful when many tables begin with the same prefix, but one is used far more often than others. With ranking, the more an object is used, the higher up the list it will appear, like browser history entries in Firefox for instance. This would reduce the number of keystrokes necessary and…
70 votesOn 14th May we released Prompt 9.5.3 which includes a feature to show recently used suggestions.
This will be the first iteration of work to rank suggestions so we’re keen to hear feedback and ideas for improvement.
More details in the release notes here: https://documentation.red-gate.com/sp9/release-notes-and-other-versions/sql-prompt-9-5-release-notes
-
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/
-
Disable SQL Prompt on certain blocks of code
Add a functionality of disabling SQL Prompt auto-formatting feature for blocks of code. Use SQL comments for 100% sql compatibility. Example:
SELECT 1, 2, 3
--<SQLPROPMT disable>
select 4, 5, 6
--</SQLPROPMT>
select 7,8,9in the code above, the first and third statements would be auto-formatted but not the second one.
It would be especially useful for very long scripts where a single formatting template is not an option.
64 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!
-
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
-
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/
-
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/
-
Support SQL Azure
Bring in support for SQL Azure for the application. If there are limitations where it cannot be done for Azure, possibly allow the user to set a local database as the model for an azure database to build the cache.
43 votesThis was shipped in v10.4.
Thank you for your input!
Chiara
-
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.
-
$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.
-
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.
-
SYSDATETIME() instead of GETDATE() as default value for datetime2 columns
When generating an insert script with default values for a table, use SYSDATETIME() instead of GETDATE() for datetime2 columns. GETDATE(), is fine for datetime columns, but for datetime2 columns, which have a larger precision SYSDATETIME() would be more appropriate.
3 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Copy column from grid results as comma separated list
Oftentimes when I am writing queries, the results from one column of one query are quickly needed in my next one in an IN clause. I highlight the column of values from the results grid and paste into the query window, and then have to append commas (and for neatness, I delete the line breaks). I would be nice to have an added option the context-menu of the results grid to add a copy as comma separated list (in addition to the current copy and copy with headers options).
16 votesThis is included in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
semi colon placed on new line
Place semi-colon on new line.
I frequently format my statements as I'm developing them, but multiple times now I've started to add an Order By or some other clause after the auto-inserted semi-colon. I would like to see an option to place the semicolon on the line following the sql statement rather than directly after. This would enable me to start typing at the start of the next line without having to check if a semicolon had been added to the preceding line.
Example:
Select * From Table
Where A = 1; -- Semicolon added by formatting
Order By A9 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!
-
Shortcut for Switching Styles
Can you add "choose style" or "switch style" to the commands section, as a drop down, so that it can be added to the SQL PROMPT toolbar? Or possibly as a hot key menu option?
I switch styles often. There's the style I like to work in, a style suited for debugging, and the style that management likes the code to be posted with (in TFS.) Being able to switch between them is very helpful. but, going to SQL Prompt --> Options --> Styles --> Selecting Style "with the mouse" is time consuming.
Thanks for your consideration!
Lawrence Barnes
10 votesWe’ve released support for quick switching of active styles in version 8 of SQL Prompt. You can right click in the editor window, select `Active Style` and then choose the style you want to switch to.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
If you are still keen to have this functionality available via a hotkey, please let us know by opening a new suggestion.
Kind regards,
The Prompt Team
-
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!
-
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/
-
Exclude Identity Field From Auto Generated Insert/Values Code For Table Variables
If a table variable or temp table has an identity field, I do not think this field should show up in the auto generated insert into/values list:
DECLARE @Table TABLE (TableId INT IDENTITY(1,1), Data VARCHAR(100);
INSERT INTO @Table
( [TableId] -- This field show not show up by default in the insert list
, [Data] )
VALUES ( 0 -- TableId - int -> This field show not show up by default in the insert values list
, '' -- Data - varchar(100)
)-- Temp Table
CREATE TABLE #Temp (TableId INT IDENTITY(1,1), Data1);INSERT INTO [#Temp] ([TableId],
[Data1]) VALUES…2 votesThis is included in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Surround list of values with quotation marks and separate by commas
when creating a WHERE colname IN ('a','b','c')
it would be nice if you could paste a set of rows from excel into SSMS and then add the quotation marks and commas
i.e.
A
B
Cbecomes
'A',
'B',
'C'7 votesSQL Prompt 7 now has an “Add quotes and commas” feature which can be accessed by selecting the block of text and tapping ctrl to bring up the Actions List. You can download the latest version 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
- Don't see your idea?