663 results found
-
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 -
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 -
Draw line from begin to end of different colors
It would be nice to have colored lines that visually enhance the start / end of a while / if statement
4 votes -
Find invalid objects in multiple databases
Please could you add an option to check for invalid objects in multiple databases and to be able to export the results in either a single file or 1 per database. It's a real pain doing 1 at a time and manually selecting the results to do a copy/paste.
4 votes -
simple tabs (brent ozar)
https://www.brentozar.com/archive/2011/06/fixing-sql-server-management-studios-tab-text/
Brent Ozar wrote this tip back in 2011 and I cant believe i've been struggling with the horrible SSMS tabs every day for my whole career. would be great if SQL prompt has a button to change these settings for you or defaults these options when you install it.
the main reason being that they are buried away and if I wasnt aware of them then i'm sure many others aren't.
at the end of every day i have about 10 tabs open and i just close the whole lot because it's too hard and to go through them…
4 votes -
Custom Aliases - Ability to Alphabetize by table name
Custom Aliases - Ability to Alphabetize by table name
4 votes -
Support for MS Dataverse / CDS
Add support so SQL Prompt will work in SSMS when connected to MS Dataverse / CDS (Common Data Service - Dynamics really).
Right now, it fails since the (meta)data exposed probably isn't quite as complete as on a "full-scale" SQL Server database
4 votes -
I would like to be able to re-name a tab without actually saving it off as a sql file.
I would like to rename tabs without having to save them as a .sql file to the filesystem. I run with alot of tabs all the time and it gets very difficult if you don't name them to find a tab that has floated into the dreaded drop down arrow. Once its there I have to walk through the whole contents of the drop down list of query windows to find the one I want. With a simple rename of the tab that could be managed by the solution file. I would be able to label them and track them…
4 votes -
Cloud Backup of all SQL Prompt Settings
Hi guys,
SQL Prompt is great. What is less great is migrating from one computer to another (or rebuilding your machine / VM / whatever).
It would be super useful if we could have a cloud backup of all SQL Prompt settings, styles, and snippets which can be associated with our licence account.
When we do an install on a new machine, we'd then be given the option to restore settings from the cloud.
4 votes -
Show only column names in intellisense while doing SELECT
Its really annoying to see table names suggestions in the intellisense while typing SELECT statement. I feel its not the new feature but its the bug to be fixed.
4 votes -
Place space before END when collapsing shorter case statements
When collapsing CASE expressions shorter then XXX, the END has no space if there is a preceding parenthesis.
Example1 = CASE t1.Col004 WHEN 1 THEN t1.Col006 END,
Example1 = CASE t1.Col004 WHEN 1 THEN TRY_CONVERT(int, t1.Col006)END4 votes -
Parentheses positioning not honoured for all parentheses, eg constraints
Using the parentheses option "expanded, to statement" for DDL, I would expect a constraint to appear with the opening parenthesis under the start of the constraint (eg, the "f" in a foreign key constraint) as follows:
MyColumn int not null foreign key references SomeTable ( someColumn )But it actually appears at the end of the same line as the constraint, and the entire contents are indented from that position:
MyColumn int not null foreign key references SomeTable( someColulmn )4 votes -
flip between adding and removing square brackets
Add ability to add or remove square brackets without having to edit the settings for which direction you want it to go.
4 votes -
format setting for "Copy as IN clause"
when I paste after "Copy as In clause", got contents like this:
IN
(
1, --comma at behind
2
)I hope got this:
IN
(
1
,2 --comma at before
)please provide option, thanks.
4 votes -
Add one additional Parenthesis style
My Teams would prefer this option:
xxxxxxxxxxxxxx (
xxxxxxx,
xxxxxxx )Opening parenthesis on the first line, and closing parenthesis on the last line.
Second and following lines indented one stop. This display seems to strip out the leading spaces.
4 votes -
Copy as WHERE clause
It would be useful to be able to copy a selection from the results grid which is pre-formatted as a WHERE clause in the same way "Copy as clause" IN works, e.g. copying a single value from ProductID column would produce WHERE ProductID = 5 and copying multiple values would produce WHERE ProductID in ( 5, 10, 15 ).
4 votes -
Add space between closing parethesis of a function call and FROM
Add an option to add a space between a function call, such as COUNT(), and FROM so that we don't end up with code like SELECT COUNT()FROM table. That doesn't happen when I select "Add spaces around parentheses" in the global parentheses options. The only way I've been able to get SQL Prompt to preserve that space is to select "Add spaces around parentheses" in the Function calls options, but I don't want a space between the function name and opening parenthesis.
4 votes -
Make the Issues List more useful - Rule Disable, Specific Help, Hide Issue in List
The list is useful to drive code positioning, but that's all it does. Rules like ST011 that go against authoritative SQLPass presentations are noise. Yes, we can click the SQP Menu, nav to manage, scroll down, and finally disable, save, then refresh... (out of breath!). Just right-click and Disable rule, which also refreshes the list. That kind of useful RC-Menu. And instead of having to go to the Rule Maint to see exactly what the rule is enforcing, RC-menu has "Show Issue Help" in a bubble, built in. And for those cases where a rule isn't to be shut down,…
4 votes -
conditions new line after
Currently we have a standard of placing new line before and after conditions with indent accordingly such that:
a=1
AND
b=2Current version only does:
a=1
AND b=2This is pretty much the only thing lacking from being able to just auto format all our procedures with a single click.
4 votes -
Additional Formatting Options
These are the typical formatting styles I use that I would like to see definable in SQL Prompt. Currently, I use a style that gets me close then manually format the remainder to the code:
Regarding the desired format of
1) SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY all lined up
2) TAB after SELECT, followed by first 'column'
3) Subsequent columns on separate lines and lined up with the first one.
4) TAB after any CASE followed by first WHEN
5) Subsequent WHENs lined up with first one
6) TAB before THEN (i.e. indented one tab from…4 votes
- Don't see your idea?