667 results found
-
SQL history - Allow user to set custom SqlHistory.db save location
SQL Prompt allows users to set custom directories for various files.
It would be nice to be able to change the location of the SqlHistory.db and other files that load to localappdata.
I would love to have this update to a folder in my oneDrive folder so it is backed up and easier to migrate between computers.
The only way to do this now is via REGEDIT.
6 votes -
Add Trim() to LTRIM(RTRIM()) toggle
For those of us who have to move between current and older versions of SQL Server, provide a tool to toggle all TRIMS in a script to LTRIM(RTRIMS()) and vice versa to make it easier to adapt scripts when moving between server version.
Thanks,
Mad Character Trimmer3 votes -
Shortcut Keys and/or Button Bar Buttons for Command Tab Options Like Add Commas and Add Quotes and Commas
When you open the command pallet the tools under the Commands tab like 'Add Commas' and 'Add Quotes and Commas' are extremely useful. It would be a tremendous time saver to not have to get to them via the menu and simply be able to assign them to Shortcut Keys and/or Toolbar buttons. There are quite a few options that can be assigned to buttons, but not these. Please consider adding this feature.
Thanks,
CommaChallenged2 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 -
2 votes
-
Fix SQL History
User of SQL Prompt for some years now. Tab History was a "killer feature". I often have multiple instances of SSMS open, with a number of ad-hoc queries open not worth saving. When I log back in, for years, WITHOUT FAIL, ALL my queries, from ALL instances would re-open.
Since "upgrading" to SQL; History, I am lucky to get one or two re-open. Complete pot luck. Even searching for known keywords to get them open again is hit and miss.
I am losing a lot of productivity due to this downgrade. I have yet to experience any benefit from the…
15 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 -
Column Order when expanding pivot is reversed
I've noticed that when I Expand * on a pivoted table, then the order of the columns gets reversed
e.g.
If I have something with a pivot
Sum(Amount) for month_no in ([1],[2],[3]....)
When the pivot result is expanded, it becomes [12],[11],[10]....
Would be nice if the expansion would match the order that the columns was entered in.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 -
Database-specific snippets
Database-specific snippets.
We have 80 or so databases scattered across 200+ instances and many tables have similar names or identical names with differing schemas: compare person.personpe, dbo.person & finance.personpe. This particular is extreme and there are more examples but the principle applies.
I would love to be able to define pe as a snippet at a database level so that I can keep my snippet names short and so that I don't have to rename them manually when I am in SSMS with a lesser used database.
1 vote -
Allow LEFT, RIGHT, INNER and OUTER JOINS to be right-aligned to SELECT.
Currently, FROM, WHERE, JOIN, and ODER can all be right-aligned to SELECT when formatting SQL. However, if you introduce a LEFT JOIN, the LEFT keyword is right-aligned to SELECT, and everything else is pushed over to make room for the JOIN. This is hideous and makes no sense.
Instead, allow the entirety of "LEFT JOIN", "RIGHT JOIN", "INNER JOIN" and "OUTER JOIN" to right-align to the SELECT keyword.
The attached images explain it better than I can.
6 votes -
Enable block comments in SQL
SQL Prompt and SSMS do not have the option to create/remove block comments. This is a serious problem.
We SQL Prompt users would love the option to add/remove block comments in SQL, between the marks /* and */, because they sometimes serve very different purposes.
Inline comment options (Ctrl + K, Ctrl + C or Ctrl + K, Ctrl + U) are helpful, but they don't always do exactly what we need. Sometimes they can break things. See below.
/*
Sometimes we need block comments that cover multiple lines.
Like this.
/
/ Or comments where each line begins and…6 votes -
Find Invalid Objects - Database Drop Down list not wide enough
The Database drop down needs to be dynamic in width or allow us to pull it wider. It is extremely difficult trying to find the database I'm working on when I have multiple installed in a LocalDB environment.
1 vote -
Remember search settings in Tab History
At present, when I search (and I hate that the search opens as a new screen), I have to click "advanced search", and select object type of "queries" (I'm really not interested in the query history, I'd rather turn it off but there's no option to do that)
The one thing that would be most useful thought would be to remember the advanced settings between uses - or maybe allow them to be saved as a search default. This would go some way to address the poor user interface changes that have made the new SQL History much harder to…
8 votes -
Suggest table names or contsraint names for DBCC CHECKCONSTRAINTS
SQL Prompt should properly suggest table names or constraint names for DBCC CHECKCONSTRAINTS.
The correct syntax would be:
DBCC CHECKCONSTRAINTS('SchemaName.TableOrConstraintName')Currently, it suggests this way:
DBCC CHECKCONSTRAINTS(TableName)
which only works if TableName is in the dbo schema.1 vote -
Auto-Correct TOP to include Parenthesis
Add an Enable checkbox in the Style Sheet | Global | Parenthesis settings.
When SQL Prompt encounters the 'old style' usage of TOP, without parenthesis, automatically enclose the apparent 'what' in parenthesis.
8 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 -
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 -
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
- Don't see your idea?