640 results found
-
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 -
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
2 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 -
New Code Analysis Rule: Flag system named constraints
It is generally bad practice to use system named constraints and there should be a rule for flagging them when there is DDL code creating one.
3 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 -
When using the "Qualify Object Names" feature, show a drop-down when multiple possibilities exist
e.g.
declare @1 table (a int, b int)
declare @2 table (a INT, b int)SELECT a, b FROM
@1 a
CROSS JOIN @2 bHere there are 2 possibilities for columns a and b, however SQL prompt only suggests the second one. Both should be shown and the user given the chance to choose.
SQL Prompt does not recognize the ambiguity nor alert the user to it (although Microsoft Intellisense does flag the ambiguity). This can result in the user selecting the wrong alias (since only one is presented, apparently the last one found) which can result in hard-to-debug…
1 vote -
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 -
Script as Insert #tempTable to snippet/placeholder text
When using the Script as Insert, it generates the Create Table with the table name as
#temptable. If you want to change that name, you have to then change it in the Create, Insert, and Drop locations.
Would be nice if this defaulted as a snippet placeholder so that editing one would edit the other two as well.3 votes -
Script as Insert
With the Script as INSERT feature, give the option to just copy the CREATE TABLE and INSERT INTO statements to the clipboard.
I regularly create Temp Tables to store query results when working through a SPROC. (Generate a dataset, throw it in a temp table to use for later, drop it at the end of the SPROC. More efficient than doing one massive Select with Subqueries.) When you Script as INSERT, that's created in a new tab. I copy that code and go back to the original tab.
Would be convenient if I could copy straight to the clipboard and…
4 votes -
Snippet placeholder for currently selected object in Object Explorer
Like the snippet placeholder $SERVER$ inserts the name of the connected SQL server and $DBNAME$ inserts the name of the connected database I would like a placeholder $OBJECTNAME$ that will insert the name of the object already selected in Object Explorer.
1 vote -
Open in Excel / Export to Excel - Choose file location for file creation
Currently the files write out to a temporary file location. Add pane in settings window to change the location (e.g. a folder in my one drive that is not read only)
3 votes -
Format on Save
Allow an option when saving / running a file that you format the sql to the format selected. Will make sure the whole team follow the standards and does not forget to run the formatter.
4 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 SQLPrompt feature into SQL MultiScript
Add support for intellisense in SQL MultiScript using SQLPrompt
1 vote -
Tab History should include non-SQL files
SSMS homes files other than .SQL scripts. Sometimes an you closed an execution plan or a deadlock graph you wish you had saved. Tab history should cache non-SQL file types along with standard SQL scripts so you can get these back when you accidentally closed SSMS or after a crash.
1 vote -
Add the ability to specify a named formatting style using a comment block.
Add the ability to specify a named formatting style using a comment block.
Add functionality to specify, in a comment block, what formatting style should be used when formatting the current file. It could be a simple addition to the existing turn-on/off formatting comment.
Perhaps something like this:
--SQL Prompt Formatting On - Style = "My Style"The above would turn on formatting and specify what style to use.
This functionality would be helpful in many ways.
It is already convenient to have multiple formatting rules, this would keep the user from having to remember what rules apply to what…
6 votes -
Add "Clean install" option during installation
Add "Clean install" checkbox with appropriate warnings and option to back up styles and tab history where the user can specify and/or change the suggested backup location by default. Offer an easy option (inside menu?) to restore from the backup once installed. Take a look at Visual Studio editor options can be exported (backed up to a file) and subsequently restored later.
Also, take a look at nVidia, AMD Radeon (formerly ATI) and perhaps Intel network card driver installers as an example for "clean install".
1 vote -
Copy results grid data to Excel as an XML spreadsheet to preserve data types
When working on a management server with SQL Prompt and SSMS, we usually don't have Microsoft Office with Excel installed there. This makes it very cumbersome to use the current feature of SQL Prompt to export grid results to an Excel file as there is no application available on the server to process the file.
Instead, I often use a very nice feature in SSMSBoost that copies to grid results data to an XML spreadsheet which can then be pasted into Excel on your client, preserving data types. The regular copy/paste from SSMS to Excel only copies text data from…
5 votes -
Correctly bracket Windows users/groups when using CTRL+B,CTRL+B
When adding brackets via CTRL+B,CTRL+B, Windows-based principals (users, groups, etc.) are not correctly bracketed. The brackets are placed around the domain or computer name portion of the principal, instead of the combination of the domain/computer and user/group name.
For example, if this statement is entered
ALTER SERVER ROLE sysadmin ADD MEMBER MYDOMAIN\USER
using CTRL+B,CTRL+B will yield this:
ALTER SERVER ROLE [sysadmin] ADD MEMBER [MYDOMAIN]\USER
instead of the correct syntax:
ALTER SERVER ROLE [sysadmin] ADD MEMBER [MYDOMAIN\USER]
Would also be helpful if principals from NT AUTHORITY and NT SERVICE could be correctly handled.
1 vote -
Object tooltips
Include SQL statements to grant existing permissions with the object definition DDL statements.
i.e. GRANT SELECT ON dbo.table TO sql_user1 vote
- Don't see your idea?