679 results found
-
VSCode integration.
I've used SQL Prompt for 20 years. I would LOVE VSCode integration.
91 votes -
fabric
Add support basic intellisense support for Fabric SQL databases (it's eq. to all Microsoft SQL database and Azure SQL DB ect.!)
7 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 -
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.5 votes -
Add IntelliSense/AutoComplete Support for ALTER ROLE...ADD/DROP MEMBER Statement
I originally submitted this as a support case when I saw that there was no IntelliSense suggestions when writing an ALTER ROLE...ADD MEMBER or ALTER ROLE...DROP MEMBER statement (the former doesn't show potential users/groups for completion and the latter doesn't show current role members for completion), but after investigation on the Redgate side I was told this was a feature that was never implemented.
It would be great if we could get support added for this please, as ALTER ROLE is a core statement that has been around for many versions, and also because the alternative methods (e.g. spaddrolemember…
1 vote -
Colorize vertical tabs
Tab coloring doesnt work in vertical tabs mode
1 vote -
Option to hide "find invalid object" menu
This feature crash SQL Server because our procedures multi-databases, encrypted and so-one and not a needed feature. But the menu is misclicked lot of times and crash SQL Server.
Could you please, add an option to hide "find invalid object" menu1 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 -
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.
5 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 -
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 -
fabric
Even if you don't add support for Fabric warehouses and lake houses soon, please detect that the current connection is to a Fabric object and quietly disable SQL Prompt's IntelliSense so it stops crashing when I connect to a Fabric lake house or warehouse.
Keeping the formatting working would still be nice though.
2 votes -
Add support for Fabric warehouses and lake houses
Add support basic intellisense support for Fabric warehouses and lake houses.
29 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 -
Align column aliases, but only up to a configurable MAX point
The alias alignment is a nice feature that improves the readability of the formatted SQL. Still, it sometimes gets lost too far to the right when the selected column values include things like SQL functions and column names. In those cases, the alignment of the column aliases can require scrolling to the right to see them with a great amount of whitespace between the column name and the aliases and they thus become a detriment to the readability of the SQL.
It would be great if we could configure a max number of spaces to align the aliases before which…
3 votes -
SQL Search endpoint for Fabric
Make SQL Search work with Fabric
1 vote -
Generate script for Table Types
When hovering over a Table Type the pop-up window only shows tabs for Summary and Dependencies. Add a Script tab for consistent functionality when compared to other types of object such as Stored Procedures, Tables, Views, Functions etc.
2 votes -
The automatic aliasing of tables and views could be improved
Say I typed the code below, just to look at the content of a table (don't slam me for the SELECT *, this is pseudo code).
SELECT * FROM dbo.Address AS A
dbo.Address was automatically aliased as "A", which is fine.
Now, let me double-click on "Address" and replace this table name with another one, just because I want to save time:
SELECT * FROM dbo.Affiliation AS A AS A
This time, the table was automatically aliased again, but your feature does not seem to care if the table was already aliases.
So now, the table is double aliased.
6 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.
5 votes -
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.
1 vote
- Don't see your idea?