713 results found
-
SQL AUTO-SYNTAX
when you insert a ssf (Select * from) you select the table and correct automatically errors like WEHRE, WERE, WEHER where the user wants to say a WHERE a logical word dictionary in which, it could be done by matching characters if all the characters written are 100% or 90% matches with word WHERE whenever is the order of the characters then autochange the text for where, This also can be matched with other KEYWORDS of SQL
2 votes -
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 -
Option to disable Redgate Assistent Startup Check
Whenever SSMS starts, SQL Prompt checks to see whether the Redgate Assistent is available, and this takes a little while.
I would like to be able to disable this startup check in options.
There is a option available to disable it, but it is already unchecked, properly due to check startup check.. But it would be nice to be able to disable it completely, so there is no startup check1 vote -
CTE name as qualifier
Currently, once SQL Prompt decides a CTE column should be qualified, it always uses the CTE name as the qualifier, without a further check for whether it's strictly necessary. Plain tables and views go through an extra step that can remove qualification when it's not needed, but CTEs don't currently have that step, so you'll always see CTE-derived columns qualified, even when there's only one source.
Could SQLPrompt be updated so that CTEs go through the same checks as tables?
For example
;With CTEMT As
(
Select
FirstName
From dbo.Users
)
Select
CTEMT.FirstName -- Avoiding CTE name being…1 vote -
$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
- Don't see your idea?