673 results found
-
Update formatting rules to handle ORDER BY inside an OVER expression
I had a query which was using ROW_NUMBER() OVER (PARTITION BY ColumnA ORDER BY ColumnB, ColumnC) and FORMAT SQL command put the ORDER BY clause as the first thing on the line (no indentation). It would be better if, when it needs to be wrapped, the ORDER BY inside an OVER was indented to line up with PARTITION BY).
1 vote -
Export snippets to text file
At times you do not always have the luxury to have SQL Prompt installed on all machines. Hence, it is extremely useful if snippets can be exported to a plain text file, so that at least one has the ability to retrieve the much needed sql scripts quickly via plain text files. It would be of great help if each snippet is exported to an individual text file that should be named like the snippet name.
3 votes -
2 votes
-
Prompt Styles As Buttons
I've created a few different style templates and named them accordingly, but when I want to add them as buttons to quickly change between styles, there is just a list of styles with no label so I don't know what any of them are.
So I have to trawl through and add each of them as a menu button until the one I want appears, which is incredibly frustrating and time consuming! When its on the menu bar as a button, it has the appropriate name rather than just "style" so can this be added to the add button menu…
3 votes -
auto create table from excel
i have file excel multi column about 100 column.
I suggest feature, when i open excel, auto create struct insert table.2 votes -
Replace the option Remove square brackets with Toggle square brackets
I usually enclose database and server names in square brackets.
Instead of only removing the square brackets, you could change that option (keeping its keyboard shortcut) to toggle between adding and removing them.3 votes -
Allow save and re-load a set of filters. We work in schemas by project and every morning starts with filtering all my objects by schema, ana
Allow save and re-load a set of filters. We work in schemas by project and every morning starts with filtering all my objects by schema, and I would love to reapply filters as a set.
2 votes -
Stop Overwriting Existing Features With new Alternatives that Aren't Merely Updates
The recent roll-out of SQL History was handled very poorly. SQL History isn't simply an update to Tab history else there would not have been the need for a name change. SQL History is an alternative feature meant to do what Tab History does (I hope) and more but on roll-out it made many of your paying customers not only angry because you replaced Tab history with it but because it wasn't ready for roll-out.
In the future when you feel the need to replace an existing beloved feature with something different and not just an update, DON'T! Instead roll…
3 votes -
snippet refresh
Snippet adds or updates are not refreshed until SSMS is restarted.
Can you add a feature to auto refresh the cache of snippets or make part of the "refresh suggestions"
3 votes -
Snippet manager improvements
Love the snippets functionality, but four improvements would be nice:
1) Fix bug that if you click off a snippet to other windows before finishing it that it will lose everything you've entered and switch back to default values for everything.
2) Add an option to finish a snippet when you tab past the final value instead of cycling back to the first snippet.
3) When you hit ESC to exit a snippet, leave the cursor where it is instead of jumping to the end of the snippet.
4) Allow user to define where the cursor should go when exiting…1 vote -
Copy as IN clause should follow formating setting
I use the Copy as IN clause a lot and think it is one of the most helpful functions in SQL Prompt.
It would be even better if it could format the IN list according to the Style setting you have selected.
This is how it is created when right clicking on the function
ContractsId IN
(
234151,
234321,
239990,
228809,
240808,
231809,
240021,
230876,
231739,
239555,
240972
)If I then use format SQL it changes it to the way I want it, without line brakes for each row but in relation to the other statement.
It would be…
5 votes -
Restore the working "Open in Excel" functionality for exporting numbers.
In version 10.12.1 and older the "Open in Excel" functionality actually created a Excel file where numbers were numbers and could be used in formulas like SUM. Starting in, I think, 10.12.4 you started exporting all numbers as a string. That completely breaks the usability, as you can then no longer make a formula using the numbers. (And while Excel offers the option to convert them back to numbers, it would be a pain to do it for each column that needed it and it takes FOREVER.)
At this point I will have to stay on 10.12.1 and not upgrade…
8 votes -
Autocomplete From User Tables
A nice SQL Prompt feature would be autocomplete using contents from user tables. For example, if I have a smallish table (this idea may be impractical for large tables) with a list of codes - state codes, statuses, categories, etc. - and I need to hard-code a value from the table in a query, it would be cool if SQL Prompt could do autocomplete from the contents of the table.
2 votes -
Operators configuration depending on where they are placed
There is a general configuration for operators AND/OR. However, for us it is important to distinguish between the different places they are used:
- JOIN
- WHERE
- CASE ...
Would it be possible to configure the AND/OR options inside each block?
3 votes -
coalesce
I often need to wrap a column in a coalesce with 0.
It would be swell if there was a feature where I could select a column, then either right click or Keyboard shortcut to have it wrapped in coalesce.
E.g. select the word
personCount
and have it be replaced with
coalesce(personCount,0) as personCount1 vote -
Format Join Order
On our team we are very particular about the order of our joins as they are written in the query. I would like to request an option to format joins so the table you are joining on is the first item in the join. In the example below you join to tableb so the first ON clause is tableb, subsequently on the tablec join the first join is on objects from tablec.
SELECT (columns)
FROM tablea a
INNER JOIN tableb b ON
a.id = b.id
INNER JOIN tablec c ON
b.id2 = c.idTo:
SELECT (columns)
FROM tablea a
INNER…2 votes -
Can we add option to have "WITH (NOLOCK)" in the Aliases tab in the Options
Can we add option to have "WITH (NOLOCK)" in the Aliases tab in the Options
2 votes -
Add Feature that shows SP Hierarchies
Add a feature that when provided an SP will enumerate every SP called with that SP and down the chain until the last SP has been listed.
NOTE: It would need to take into account circular references in which case once an SP has been enumerated if it's found again it's listed but nothing else after since that will have already been done once.
2 votes -
CREATE TABLE align data-types
When making a CREATE TABLE statement, there should be a formatting option to align the data-type behind the field names.
2 votes -
DDL comma placement
When making a CREATE TABLE statement, I would like to have the comma at the beginning of the line.
I've set the lists.placeCommasBeforeItems property to true, but it's not working for the DDL statement.So either fix the comma placement option for DDL statements or add an option for it.
2 votes
- Don't see your idea?