698 results found
-
Copy (just) 1 or more headers from result
I would like the ability to select 1 or more values in a result and have the (right-click?) option to select header(s). I then have the header, or headers separated with commas in my clipboard.
1 vote -
Search for column in result
I would LOVE! the ability to have a search window with my results from a query, where I type in any part of a column name and it lists all columns containing value I typed in.
By default one is positioned on the applicable column in the result (scrolling if necessary in wider result set), but if one clicks on any column matching value then it positions one on that column in the result.1 vote -
FREEZES SSMS - Add what tool (name) caused the error to the title of an error window
The error popup comes out of nowhere when navigating SSMS tree nodes, notably when selecting a specific database name. I expected it came from SQL Prompt, but there was nothing being logged even when verbose option has been enabled.
The support helped clarify it "probably" came from SQL Source Control installed recently.
Also, the "Send Error Report" never worked.
The error completely freezes SSMS as it is a modal.
It has to be dismissed multiple times and then navigated away from the selected database back to a server's name - quickly using a keyboard.
1 vote -
Refactoring: Convert expression to cross apply
Working with a query that contains the same expression multiple times, I often want to extract all instances of that expression into a CROSS APPLY for readability and ease of modification, e.g. converting something like this horribleness:
select foo = case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end, count(*)
from baz
where case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end in ('a','b')
group by case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' endinto something more manageable…
1 vote -
make update notification window resizable or autosize with Windows zoom
I like to use the Windows zoom feature to make text bigger. (Not the dpi size feature, but rather the text size feature listed above the dpi setting.)
With this increased, I cannot see the links in Red Gate update notification windows. I'll open SSMS and get a notification for prompt that I am running 1.0.7 and the latest version is 1.0.8. There is a details link that allows me to upgrade. I can also upgrade by downloading the latest version of the tools from the Red Gate web site.
However, for minor upgrades, I often skip the upgrade process…
1 vote -
Show Code Window Even if Schema is Missing
When I scroll over an object *table, view, function, stored procedure), SQL Prompt typically displays a tooltip that describes what the object is (e.g. Table). I can click on the tooltip and see a script of the object.
However, if I have not included the schema, then I do not get the tooltip, but rather a warning that "Schema name for table or view is not specified" and I am not able to view the object code without either disabling that alert or adding the schema name.
While it may be advantageous to have this rule enabled, it would also…
1 vote -
Go to variable definition
I would like a feature that allows a user to right click on a variable name and allow for an option of
Go To Declarationso it would scroll up to the place where the variable is declared. The hover option shows how it is defined, but not where it is defined which is also extremely helpful when troubleshooting and researching a script.7 votes -
HoverOver Popup Incorrect
Using SSMS 21.4.8 and SQL Prompt 11.0.6.17341.
Using a derived select to retrieve data then derive select that to change the data types then a third derived select to present the data.
In the inner most SELECT, the fields OrderID and OrderItemID are Integer in both the the Microsoft and SQL Prompt HoverOver popups.
In the outer most SELECT, the OrderID and OrderItemID are Varchar in the Microsoft HoverOver popup but Integer in the SQL Prompt HoverOver popups.
Also in the outer most SELECT, down in the ORDER BY, they show differently hovering over between the Microsoft and SQL prompt…
1 vote -
Alignment of nulls
How can we get the following alignment with nulls? Please review the pre & post images attached
1 vote -
Add or detect missing 'N' on inline string literals containing Unicode characters
This is an extension of:
https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/6779217-add-n-to-unicode-type-literal-stringsExcept I would like to improve this feature so that it is not limited to just variable declarations, but also for inline string literals.
For example, if an inline string literal contains a unicode character, it should have the N prefix. If anything it should probably be a Code Analysis rule rather than formatting because this change can absolutely impact code behavior. So I think it's better suited to be an analysis rule.
6 votes -
Keyword KEEP_CDC not recognized in RESTORE statement
Add support for the KEEP_CDC keyword. Example:
RESTORE DATABASE MyDB FROM DISK = N'\\SOMEWHERE\MyDB_FULLBACKUP1.BAK' WITH FILE = 1, MOVE N'MyDB_DATA' TO N'M:\SQLData1\SQL_DATABASE\MyDB.MDF', MOVE N'MyDB_LOG' TO N'M:\SQLLogs1\SQL_DATABASE\MyDB_LOG.LDF', RECOVERY, REPLACE, STATS = 1, KEEP_CDC, NEW_BROKER, RESTRICTED_USERCurrently the formatting process errors out.
1 vote -
Automate replacing variables with literals for troubleshooting stored procedures
Quite often when troubleshooting a stored procedure, it is helpful to step through it and run each statement individually. In stored procedures that take parameters, though, you need to manually swap out the variable name for a test value in each statement, or put variable declarations and sets in front of each statement.
It would be convenient if SQL Prompt could automate this process. It could check for parameters, prompt the user to provide values for them, then do the variable-to-literal substitution throughout the code. It could then provide an easy way to reverse the change to support committing the…
1 vote -
SQL Search endpoint for Fabric
Make SQL Search work with Fabric
2 votes -
exclude suggestions
SQL Prompt includes a feature to exclude specific databases – in this case, the master database – we would expect this functionality to reliably prevent any interaction with the excluded databases during code suggestions or IntelliSense operations. The current behavior suggests that the exclusion option may not be functioning as intended.
We expect that when an exclusion is defined, no connection attempt should be made to the excluded database. This would allow all other user databases to be loaded, even if with limited functionality.
pls. check http://productsupport.red-gate.com/hc/requests/333558
1 vote -
Add support for Fabric warehouses and lake houses
Add support basic intellisense support for Fabric warehouses and lake houses.
37 votes -
Set preferences for automatically numbering new queries
New queries, as users know, have an automatic naming and numbering system:
SQLQuery1.sql, SQLQuery2.sql, SQLQuery3.sql, etc.It would be helpful sometimes if the queries could have leading zeros or maybe even a different lead-in like the name of the solution. For example, SQLSolutionABC might have the default tab names:
SQLSolutionABC001.sql, SQLSolutionABC002.sql, SQLSolutionABC003.sql, etc.
1 vote -
frequently use the ScriptObjectAsAlter shortcut in Visual Studio to modify views and procedures. However, when the script opens, it default
frequently use the ScriptObjectAsAlter shortcut in Visual Studio to modify views and procedures. However, when the script opens, it defaults to ALTER VIEW or ALTER PROC, while our source control requires everything to be saved as CREATE OR ALTER.
Would it be possible to introduce an option in SQL Prompt to default these scripts to CREATE OR ALTER instead of just ALTER? This would streamline the process and reduce manual edits before committing changes.
2 votes -
Intellisense for system stored procedure parameter values
For system stored procedures, some parameters have a predefined set of possible values, e.g.
msdb.dbo.sp_add_jobstephas the parameter@on_success_action.The MS documentation lists this predefined list of possible values:
1 (Default) Quit with success
2 Quit with failure
3 Go to next step
4 Go to step@on_success_step_idIt would be great if Intellisense could suggest values for these sorts of parameters, saving a trip to Microsoft's website.
5 votes -
Surround highlighted text with
Surround highlighted text with 'thing' instead of replacing it. Like in azure data studio or visual studio, pressing "(" will surround the highlighted text instead of replacing it. I have created surround snippets to surround the highlighted text with what I want; it's just not as good to use.
6 votes -
Add a warning for using a self-join in a delete or update statement
Add a checkbox to the warnings settings, for if a self-join is detected when doing an UPDATE or DELETE.
1 vote
- Don't see your idea?