Skip to content

How can we improve SQL Prompt?

SQL Prompt: Code Analysis

CATEGORIES
All ideas
My feedback
Code Analysis 48 ideas
Encapsulate as new stored procedure 1 idea
Expand wildcards 7 ideas
Find invalid objects 7 ideas
Find unused variables 3 ideas
Format SQL 187 ideas
Intellisense 77 ideas
Platform Support 16 ideas
Qualify object names 6 ideas
Script object as alter 14 ideas
Smart rename 10 ideas
Summarize script 5 ideas
Tab coloring 5 ideas
Tab history 42 ideas
User interface 88 ideas

Searching…

No results.
Clear search results

- Flyway 15 ideas
- MySQL tools 24 ideas
- Oracle 129 ideas
- Redgate 0 ideas
- SQL Change Automation 50 ideas
- SQL Compare 249 ideas
- SQL Data Compare 110 ideas
- SQL Prompt 663 ideas
- SQL Search 133 ideas
- SQL Source Control 588 ideas
- SQL Toolbelt Essentials 16 ideas
Redgate

PE019

I'd like to vote for adding PE019 (Consider using EXISTS instead of IN) to the issues which can be auto-fixed.

It feels like the kind of re-write that would probably be simpler for a computer to do than a person.

5 votes

Ned Bush shared this idea · Feb 1, 2019 · Report… · Admin →

An error occurred while saving the comment

Anonymous commented · April 8, 2020 4:20 AM · Report

Just to raise a concern about performance issues caused by making the changes suggested by PE019...as expressed at https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/40116010-remove-pe019-consider-using-exists-instead-of-in

Submitting...