643 results found
-
Swap commented / uncommented lines in selection
Using a shortcut to swap commented / uncommented lines in the sql script. This could be very helpful when we need to test (select / update) for the same source query.
Please check the screenshots
Thanks
6 votes -
Make auto savings of my open queries in case the program suddenly crashes
Sometimes my SSMS crashes. The Crash recovery of the program is not good enough. Would love to see "auto save" option that will save the open queries to history each time I'm idle for few moments. It would be much easier to recover than reproduce
4 votes -
Tab Color accessibility compliant
Tab Colors add a great feature to know I am on a production server. It would be improved by being accessibility compliant. In the attached you can see black on red is harder to see than white on red.
1 vote -
Prohibit SQL execution in case of UPDATE/DELETE without clause
At the moment a user is warned before executing a potentially dangerous operation.
However, junior devs might accidentally just press enter without thinking twice.
Please add functionality to PROHIBIT execution besides WARNING (like SSMS Boost has) so that junior devs can't make mistakes at all.
It would be fantastic if this would be possible.2 votes -
Table Column Format Correction
In cases where there is SELECT DISTINCT or SELECT TOP(n) .. I would l like the option to format my table's columns to appear on the next line and indented 1 tab or set of spaces in from the SELECT and not necessarily aligned with DISTINCT or TOP in the line above.
SELECT DISTINCT
COLUMN1,
COLUMN2
FROM ...instead of
SELECT DISTINCT
Column1,
Column2
FROM ...2 votes -
Allow searching with regex in "SQL Search"
Currently it is hardly possible to search for column assignments like "Column1 = 0". The results include any words having zero.
This request is similar to the "allow multiple keywords searches", but it is for a button named "SQL Search" instead of "Tab History".
Either treat "match whole words only" as the entire search text entered is matched exactly or introduce another checkbox "Search as Regex" to handle this scenario.
1 vote -
Add your software to Microsoft Windows Package Manager (aka WinGet)
There is a new toy in town. Microsoft Windows Package Manager https://github.com/microsoft/winget-pkgs
I expect you to add your applications there. Thanks in advance2 votes -
Make the column picker the default tab when suggesting columns inside a select
Make the column picker the default tab when suggesting columns when the ursor is inside a select statement.
2 votes -
Ability to choose schema when there are multiple objects with the same name exists
Currently when SQL code is formatted, it will pick the first schema, if there are multiple objects with same name but having different schemas. It would be good if the choice is given to the user to choose which schema.objectname to use in this case.
Also it's better if we can exclude certain schema's to be considered during code format. (But want to see the intellisense. Only to exclude them during the code format)
3 votes -
Allow block comments /* SQL Prompt formatting off */ to disable T-SQL formatting
SQL Prompt should allow block comments /* SQL Prompt formatting off */ to disable T-SQL formatting.
Single line comments are a pain when tuning queries. I would always use block comments in my code except when I don't want SQL Prompt to not mess with certain T-SQL it does not format to my standards.
Blocking formatting should support both type of comments.
/* SQL Prompt formatting off */
-- SQL Prompt formatting off6 votes -
Ability to exclude certain objects (Procedures/Functions/Files...etc.) from being processed for a rule
Currently there is no way to tell Code Analysis to ignore this specific object for a specific rule which has led to several false positives and wasted time re-investigating how to address the issue in the object only to come to the same conclusion as before that this is one of the rare cases where breaking that rule is ok.
My example is we have one stored procedure out of a thousand where the use of a NVARCHAR(2) makes sense and is actually more efficient then switching to a NCHAR(2) for what the code needs to do. Unfortunately the procedure…
4 votes -
Replace all inline comments with block comments
It would be really useful to be able to choose the default comment style as either inline -- or comment block /* */, and have that style be applied when executing an auto-format on the script.
See https://www.erikdarlingdata.com/sql-server/please-use-block-quotes-for-code-comments-in-your-t-sql/ for more info
17 votes -
In the tables population dialog allow more filtering options - say, filter by schema, by name, etc
Allow more filtering options for populate tables with data tool.
1 vote -
For the SQL Compare tool allow to copy warnings texts
My idea is for the SQL Compare tool: when the warnings are displayed, it would be helpful to be able to copy text of these warnings to deal with them
1 vote -
"Manage Code Analysis Rules..." should also be available from the "Options..."-menu
All setup-options, except "Manage Code Analysis Rules..." seems to also be available from the "Options..." menu, which is nice ...
1 vote -
Export settings doesn't export snippets
When I export my settings, my own snippets are not exported.
4 votes -
Suggest common day and time constants when a date/datetime field appears as a criteria
When a date or datetime field appears in a WHERE clause, include Suggestions of the following nature and dynamically substitute them upon selection with the nondeterministic or deterministic equivalents:
(I couldn't get my table to format nicely here - please see the copy in the uploaded file.)
(If it's currently 11am on Friday August 20 2021...)
Suggestion Nondeterministic replacement Deterministic replacement
now GETDATE() CAST('11am 20 August 2021' AS DATETIME)
today CAST(GETDATE() AS DATE) CAST('20 August 2021' AS DATE)
yesterday DATEADD(DAY, -1, CAST(GETDATE() AS DATE)) CAST('19 August 2021' AS DATE)
tomorrow DATEADD(DAY, 1, CAST(GETDATE() AS DATE)) CAST('21 August 2021' AS DATE)…1 vote -
Find invalid objects in script
Highlighting invalid objects is a nice feature, but it would also be nice to "find" invalid objects in a script.
Running SQL Format on a script with an invalid object in it runs fine and gives no error, it just doesn't prefix the object (like a table) with the schema.
It would be nice to have a quick and easy way to "go to next invalid object" or even for when you run SQL Format to have it bring up a warning saying "this/these object/s appear to be invalid".3 votes -
Fix the confusing multiple usage of your company name
You should fix the use of multiple versions of your name (Red Gate | Red-Gate | Redgate | redgate | red-gate) across all software and communications. See attached picture.
We try to promote your products in our consulting company, but everyone uses a different name to refer to your company.
4 votes -
Separate ALIAS Alignment - table vs. column
Aligning based on column-alias makes for much better readability. When turned OFF, because some long-named table's alias pushes the TABLE-alias way to the right, all other table aliases follow it...into the NON-VISIBLE area (when using multiple vertical tabs).
Please SEPARATE these into TWO options:
. Align Column Aliases - on/off
. Align Table Aliases - on/offTHERE IS A BUG TO FIX HERE TOO: If a UDF is bounded by "--SQL Prompt formatting off/on" the TABLE ALIAS position REMAINS as if the UDF's alias was in it's SQL Prompt position, NOT where the excluded code has it! NASTY.
You could…
5 votes
- Don't see your idea?