670 results found
-
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 -
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 -
Include some menu options directly in Style format
Would it be possible to include the attached menu options in the Style format configuration? It would be very helpful to have it when Formatting SQL instaead of executing it after the Format.
At least, "Apply Casing Options", "Qualify Object Names" and "Remove Square Brackets".2 votes -
Maintain TABs before comments
We have some comments placed in the code preceeded by one or more TABs. When formatting SQL all these TABs are replaced by one WHITESPACE.
Is it possible to maiantain these TABs?See attached examples.
2 votes -
Semicolons deletion
We would like an option to get rid of the semicolons. You can only configure the whitespace. When we apply "Format SQL" many semicolons are inserted in our code and we don't wnat them.
Is it possible to add an option when formatting Style for eliminating semicolons?2 votes -
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 -
enable renaming queries that are found by the search (starred queries)
It should be possible to rename queries that are found by the search. Especially this concerns "starred queries". Unfortunately, the list of found queries lacks the small 3-dot menu that is available in the unfiltered list. And there you can rename a query if it is not currently open.
That had worked in the old tab history. And it was a very important tool for me to save my queries under meaningful names.
2 votes -
NOLOCK
Add a Refactor/Reformat option to REMOVE NOLOCK HINTS - with the NOLOCK hint deprecated and the hint being ignored in SQL Server 2022 and beyond, it would be great if refactor option in SQL Prompt to quickly remove WITH (NOLOCK) or (NOLOCK) hints from the selected SQL. It will be useable for years when addressing older SQL that utilized that hint. It would be helpful for the next decade at least to have a quick way to clean up the old SQL statements. If you can imagine how many times NOLOCK hints have been used in SQL Server over the…
2 votes -
Load Suggestion
When opening a "New Query" window in Sql Server Management Studio (SSMS), SQL promt automatically load suggestions every time.
If the connection with the server is strong, this tipically takes about 1-2 seconds.
I am using a VPN that has a low bandwith and i have to wait 30-40 seconds every time i open such a window.
Since i have the possibility to load the suggestions manually using CTRL + SHIFT + D,
it would be great to have a setting that will prevent loading suggestion in every situation as described above.
Just store the suggestions in the cache first…2 votes -
Smart Rename User Defined Table Types
There is no Smart Rename option for User Defined Table Types. This should be implemented.
2 votes -
Can't see Full Database name
using LocalDB, the database path names can be rather long, and in the Sql Prompt Invalid objects UI, there isn't a way to expand the database name, no pull handles or widening of the screen doesn't change the comboboxs dimensions which makes it hard to find the one I need without clicking through each one.
2 votes -
SQL History
Recent queries section has date sections wrong. It is showing queries from last night as today. Maybe a time zone thing? It should use the machine's time zone.
2 votes -
Connect queries on SSMS open but do not refresh suggestions
In prior versions, SQL Prompt would connect open queries as SSMS was opening but it would not refresh suggestions (index associated database) until an open query tab was activated (selected).
The current version (10.13.3.32087) still connects open queries but it also refreshes suggestions for all open queries as it is connecting them.
This leads to a sluggish experience with both typing and an increased delay in the time it takes for SQL Prompt suggestions to display. I suspect it is due to the large amount of cached suggestions.
I typically leave many query tabs open when working in SSMS so…
2 votes -
Installer should remember if I installed last to SSMS only and default to that
I am installing SQL Prompt into SSMS only. every time I run an update I need to change the install location to SSMS only (from SSMS and VS). Please make the installer remember my selection and default to it
2 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 -
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 -
Enhance shortcut that qualifies object names to also do cleanup
Qualify object names [Ctrl+B;Ctrl+Q] should also clean up three and four part column references
2 votes -
Additional options for formatting a GROUP BY clause
It would be appreciated if you could enhance the SqlPrompt Formatting Styles functionality. I believe this would go in the STATEMENTS >>> Data (DML) section.
I'd like to continue using the "If there are multiple expressions" item of the "Place GROUP BY / ORDER BY expression on new line" drop-down. But I'd like those expressions to be indented; they presently all left-align to the GROUP BY.
Also, while you're there, it seems that it would be good to also have add an "If longer than wrap column" option to the above-mentioned drop-down.
2 votes -
Show SPID in tab history for open tabs
For tabs with an open connection, show the SPID # in the list on the left side
2 votes -
Allow a Dark Theme for the Toolbelt GUIs
Allow dark theme for all GUI interfaces in Prompt.
2 votes
- Don't see your idea?