710 results found
-
IN clause - indent according to parenthesis rules according to the expression they are in
It would be nice if the IN clause were formatted like a logical function that returns a value so that it followed the options and rules for parentheses and were indented according to its place in the logical expression. (paying attention to the ANDs and ORs if present)
2 votes -
Offline TSQL code analysis and Standardization report..Where we can add custom rules regarding to company naming procedure
My Name is Waleed Abrar and my license number is. I am actively looking of Static TSQL Analysis and I was really happy with the SQL Prompt. I have done some analysis and implemented some test cases. It works really good working live and parallel to development . I want to ask if it’s possible to do an offline analysis and get a HTML or Excel report for a particular database about the TSQL code Quality inside the DB. For Example I can select the Database ‘XYZ’ and then click Analyze static code. It will give me a report back…
2 votes -
Code Analysis EI028 Incorrectly Identified When Adding Not Null Column With Explicitly Defined Default Value
Stop raising EI028 when adding columns using style:
ALTER TABLE dbo.MyTable
ADD TestColumnB CHAR(1) NOT NULL,
CONSTRAINT DFMyTableTestColumnB DEFAULT ('B')
FOR TestColumnB;2 votes -
EI003 to allow variable assignment of MIN and MAX and Scalar-valued function results
At the moment a warning is given "Non-scalar subquery in place of a scalar" when trying to assign a variable to the result of a MIN or MAX query which would only result in a single value. Also get the warning when i create a Scalar valued function and assign variable to result of a call to that. In each of these case only one result can be returned so the warning appears inaccurate and wrapping the result in a TOP 1 { } ORDER BY statement seems an overkill just to remove the warning
2 votes -
Create "declare table" snippets
I am in the process of converting many Stored Procedures to UDFs (for various reasons).
One thing that is irritating is that these SPs often use the SELECT x, y, z INTO #tempTable pattern.
Would that be possible for you to generate the equivalent DECLARE @tempTable TABLE ( x TYPE,y TYPE,z TYPE) statement?
That would have proven to be very helpful!
2 votes -
Intellisense for Linked Server connection to MySQL ODBC
I have been using SQL Prompt for awhile and one of the best feature I like about it is the fact that Intellisense works even on Linked Server to other MSSQL databases.
Recently however, I have set up Linked server to MySQL ODBC connections and I noticed that Intellisense is no longer returning the table names and column names in the predictive boxes.
I then tested this to other ODBC connection. I set up Firebird (DB2) and Oracle and Intellisense seems to be working for these (only for table names, not columns but that's better than nothing).
Is there a…
2 votes -
$FILENAME$ Snippet Placeholder
It would be helpful to have a snippet placeholder called $FILENAME$ that inserts the current script filename. Many of us are using database projects with SSMS, Visual Studio Code and Visual Studio where SQL objects each have their own file in the project.
1 vote -
Do not analyze files larger than N lines
For suggestions, auto-complete, and code analysis, very large SQL scripts cause excessive latency and can crash SSMS.
Please add an option where a file that is longer than N lines will not be automatically scanned/validated.
Use-Case: Complex database build scripts, schema source files, or other scenarios where a script can be tens of thousands of lines long require me to disable SQL Prompt before opening. Failure to disable SQL Prompt results in minutes of excessive latency and the inability to move the mouse around easily, type, or take any actions. This often leads to crashes, as well, either of the…
1 vote -
phishing resistant mfa
Could you please consider adding support for phishing-resistant MFA? Currently, it is not supported.
When staff attempt to authenticate using their passkey, the application displays an error indicating that this feature is not supported. I have been in contact with Red Gate support, and they have advised me to raise this request for consideration in a future release.
1 vote -
Show all index definition details in table script popup
The script preview in the table popup window, doesn't show all the options for create index and primary keys; for example, fill factor is reported, but if a primary key is defined with the OPTIMIZEFORSEQUENTIAL_KEY = ON option, that is not stated.
1 vote -
disable notifications
The pop up that you get when it's slow to gather the cache just clutters up the screen or is a pain to dismiss. I usually just pin it to the side and at the bottom of the object explorer so it sorta disappears forever. But it would be nice to have an option to not even get an alert.
1 vote -
SQL Prompt has no separate configuration for aligning CTE names or OVER()
I would like to be able to control how CTE names and OVER() are aligned. Right now CTE names seem to be part of the general list configuration, but in my case the CTE names are indented. And the OVER() parentheses and content isn't aligned how I set up my parentheses settings (see attached screenshots)
1 vote -
SQL Prompt parentheses alignment for (NOT) IN/(NOT) EXISTS
Parentheses alignment not working as expected for [NOT] IN/[NOT] EXISTS, should be aligned with current statement but the parentheses are indented (please see screenshot attached)
(SQL Prompt 11.3.6)
1 vote -
When changing connections, if the original database exists on the connection, make it the current database
Often times, when I am changing connections (ie servers), it would be nice to have the current database change to the database I was on prior to the connection change.
For example, if I'm on the database Adventure on Server1 and change connections to Server 2, that the current database change from whatever my default database is, to Adventure as well.
Yes I know I could fix this with a use database command, but I also feel SQL Prompt could just do it for me.
1 vote -
Support strict encryption
Hassan Imam (Support) confirms that SQL Prompt does not currently support the 'Strict' encryption mode introduced in SQL Server 2022. Your connection handling currently treats encryption as a simple on/off option and hasn't yet been updated to support the newer encryption levels (Optional, Mandatory, and Strict).
Please support Strict encryption.
1 vote -
find in results
What would be invaluable is to have a "Find in Results" ctrl+f type functionality whereby you could locate a specific value within the Results - either within a specific column or just within the results generally. Other SSMS add-ins have this capability and it's very convenient!
1 vote -
Format SQL: ability to turn ANY formatting “subcategory“ OFF
A large number of the SQL Format subcategories already give you the drop-down option to leave the current code “as-is”, for that given subcategory. It would be useful if this functionality extended to EVERY formatting subcategory; perhaps by way of an On/Off checkbox.
The use case here: some teams may have agreed-upon formatting rules that only apply to a very small list of all possible formatting subcategories, and want to use Format SQL to automatically deploy these changes onto preexisting SQL statements WITHOUT affecting other formatting subcategories that they don’t care about. This can greatly reduce added noise to DIFFs…
1 vote -
Intercept F5 and warn if nothing selected
When I hit F5 in an SSMS window where I'm trying to DELETE without a WHERE clause, SQL Prompt intercepts this and gives an Execution Warning. That's great. Is there a way to do a similar warning if hitting F5 with nothing selected, which executes everything in the script file?
In my opinion, that is VERY dangerous because I jump back and forth between SSMS and Visual Studio, where F5 just runs a program. I rarely would want the F5 to execute everything.
Of course, it would need to be an option that could be turned off via “Don't show…1 vote -
Search - Add multi select and Remove query
SQL History Search - Add multi select (CTRL+click and/or Shift+click) and Remove query option
1 vote -
Fix bug that causes SQL Prompt to crash when RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml is locked
SSMS will freeze up and become unusable whenever RedGateSQLPromptCommonUIOptionsUIOptions.xml is being used by another program. Users can no longer use SSMS when this occurs and need to restart their computer when this happens. This has been very disruptive for the development team as this occurs multiple times per week.
1 vote
- Don't see your idea?