674 results found
-
Add 'Reconnect All tabs' button
Great improvement (at least for me, but I doubt I am alone with this issue) to connect all tabs on opening SSMS would be to enable to invoke this on click/keyboard shortcut.
I am working through VPN and every disconnect means I have to close and re-open the app, losing pinned tab status and tab ordering.4 votes -
Add Per Database table/view alias mapping dictionary for use with Qualify object names
It would be nice to have a setting per database in SQL Prompt that would allow us to set an alias to tablename mapping and these settings can be shared / stored in source control for other developers.
When we run the qualify object name operation it could look at this dictionary and automatically inject an new alias for an old alias or table/view with no alias.
This allows us to have consistently alias'd tables across all sql objects in source control.
2 votes -
Where clause should suggest column first, then variable
When typing in a where clause, the column name should be suggested first, then the variable.
1 vote -
restore from url breaks SQL formatter
The below script causes SQL Formatter rules to fail with the error "Script parsing error(s) ... Incorrect syntax near url. ... Failed refactorings: Insert semicolons (Script parsing errors)"
create database foo; go backup database foo to url = N'https://foocorp.blob.core.windows.net/backups/foo/foo_1.bak'; go restore database foo from url = N'https://foocorp.blob.core.windows.net/backups/foo/foo_1.bak'; goSSMS Parse (
ctrl+F5) reveals that this snippet parses correctly. When replaced with a valid URL target, this syntax also executes without error.Please update the semicolon rule and any other necessary rules to handle for backup/restore from URL as a valid formattable syntax.
(possibly related? https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/40184173-format-sql-backup-to-url-with-credential-breaks-co)
1 vote -
Have formatting features for cross join match those of left/right/inner join
I have set up rules to format as such:
Select *
From Employees e Join
People p On e.PersonID = p.PersonID;Each table/view object aligned on a new line. However, when I convert to a "cross join", they don't generate a new line, they concatenate on the same line, like such:
Select *
From Employees e Cross Join People p;3 votes -
Compare the output and speed of two stored procedures
Add a new window that compares the output (and speed) of two stored procedures using the same parameters (ignoring parameters that are missing on either side).
When fixing performance problems or adding new parameters to existing stored procedures, we often need to rewrite large portions.
After successfully speeding it up, we need to test if the results are still correct.
One way to do this is to compare the output of the new procedure with the output of the old one using different parameters. This involves storing results in temp tables, sorting them, output to a text file and using…2 votes -
Generate C#/VB.NET class
It would be nice to have the ability to right-click on a table or stored procedure and generate a C# or VB.NET class from the table structure or stored procedure results that could be used in a development solution.
3 votes -
Possibility to search for multiple keywords
It would be nice to search for multiple keywords in the Tab History. For example, I know I had a script to insert data from TableA to TableB, but I searching for TableA or TableB yields to much result (both are frequently use tables). Searching for "TableA, TableB" or "TableA*TableB" would be a good quality of life feature.
12 votes -
ADS wildcard extension
Please add the wildcard extension (select * => select col1, col2, ...) to SqlPrompt in ADS, the same as it works in SSMS.
6 votes -
Include snippets in command palette searches
It would be useful to have snippets included when searching in the command palette. Selecting snippet would open snippet editor with focus on the selected snippet.
1 vote -
remove square brackets from keywords like MATCH clause in a graph table join
when formatting SQL, do not automatically add brackets to the MATCH clause when querying graph tables
1 vote -
Click to run pinned queries
I often find myself in a scenario where I am doing something like:
1. Mock some data (SQL query)
2. Perform a front end action as though I'm a user
3. Check some data (SQL query)
4. Alter a procedure (SQL query in a different window)
5. RepeatI think it would be nice if I could pin the mock/check queries to a window in the side of the manager so that I could click to run them instead of having to click in them then shift+f5 or whatever. And even more nice not having to have a second editor…
1 vote -
Additional options for formatting the ON constraints of a JOIN
It would be appreciated if you could enhance the SqlPrompt Formatting Styles functionality for the Clauses >>> JOIN section. I'd like the ON keyword to stay on the same line as the table-name, but when constraints are line-wrapped, I'd just like them to be "normally" indented.
Presently, the only way to get close to this behavior is to check the "Place ON keyword on new line" checkbox and set "ON keyword alignment" to "Indented". But I don't want that box checked.
3 votes -
Include views and unsaved tabs in recoverable tabs
When SMSS closes (either by user interaction or unintended closure), SQL Prompt does not save the tabs when I am working in a view. It only saves the tabs that are queries, saved or unsaved. The problem with this is that many times I am creating a view, or working with views. These are never saved with SQL Prompt, so the tab history feature is more or less useless. Redgate needs to include views and unsaved tabs in the recoverable tabs list.
1 vote -
Bulk Formatting or Bulk Code Analysis
It would be nice if the new Bulk Formatting or Bulk Code Analysis functionality could also target items directly in the database. This would save time because I wouldn't first have to save objects definitions to my computer.
1 vote -
Allow GitHub public sharing of snippets and styles
Allowing styles or snippets to be shared publicly would be a great feature. This could be potentially be done using GitHub repos and/or Gists.
1 vote -
refactor SELECT into CTE
The way I work when creating complicated scripts is creating all the SELECT statements and then convert them to CTEs of my final query.
It would be nice if you could convert SELECT into CTE7 votes -
Load built-in functions first in the suggestions list
Would it be possible to load built-in functions into the suggestions menu first (or alternatively, ignore keystrokes until the suggestion list is fully loaded)?
An example scenario is I type "max(" and it picks up the first user-defined object name from the menu. It appears the built-in functions are loaded after the user-defined objects (although they appear at the top).
In the attached file, the example is that MaxActionId will be selected when I type "max(" too quickly. This is a small but irritating problem because I have to remember to wait momentarily after typing a function name to avoid…
1 vote -
Add Feature to Qualify Object Name on files in a folder / directory / sql database
As SQL Prompt user, I want to be able to perform a qualify object names operation on a directory of views, tables, sprocs, etc.
Currently, one must open a sql file in SSMS first then run the qualify object names operation on each file. This is extremely time consuming. We are trying to improve our code quality and readabily by following best practices.
1 vote -
Unformat Query
Add a menu Item option to unformat a query. In other words take the query that is highlighted or every query in the script and convert them to be on a single line with only a single space between keywords, words, and operators.
This would be very useful for having to copy SQL into a table or other some object that shouldn't have normal formatting in it.
An option would be to double up all single quotes, so that the query can be placed between single quotes.6 votes
- Don't see your idea?