674 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 -
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 -
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 -
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 -
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 -
history connection
As I click open on a query in SQL History it gets displayed in a new tab. However this tab has no active connection. To be able to run the query I have to connect the tab manually to the database.
For me it would be much easier if opening the query from History would also open a connection to the database the query ran the last time.If there are specific reasons why this was not implemented it would still be nice, if there were an option available to automatically connect to the server.
1 vote -
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 -
Support for Synapse Serverless / On-Demand
Please add support for Synapse Serverless Databases for Intellisense!
20 votes -
Revisit "Formatting SQL Transaction"
A previous request titled "Formatting SQL Transaction" was flagged as Completed in 2018; however, no option to adjust the formatting for BEGIN TRAN / COMMIT TRAN blocks exists in the latest release of SQL Prompt version 10.
1 vote -
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 -
Exclude standard column names from join suggestions
We add certain standard columns to all tables (LastUpdatedDate for example). Would be great to be able to set a list of these columns in the Options so they can be excluded from list of suggested JOINS
3 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 -
Export to Excel bug -- Excel says it needs to repair data
Since upgrading to latest version of SQL Prompt, I seem to be getting an error from Excel when I choose "Open in Excel". The XML recovery log looks like this:
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error09000001.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\ned.bush\AppData\Local\Temp\raovxova.xw3\Exported results 2022-10-2509-18-50.xlsx'</summary>
<repairedParts>
<repairedPart>Repaired Part: /xl/worksheets/sheet1.xml part with XML error. HRESULT 0x8000ffff Line 1, column 0.</repairedPart>
</repairedParts>
</recoveryLog>4 votes -
Create shortcut to filter setting
Hello Redgate and the community,
During my day to day work, it would be greatly helpful to get a shortcut to enter the filter setting menu, not only on databases, but also tables, views and stored procedures and what not, just a global shortcut, to enter the filter setting on the selected folder (if that is available for the folder)3 votes
- Don't see your idea?