Skip to content

How can we improve SQL Prompt?

SQL Prompt: Format SQL

CATEGORIES
All ideas
My feedback
Code Analysis 50 ideas
Encapsulate as new stored procedure 1 idea
Expand wildcards 7 ideas
Find invalid objects 9 ideas
Find unused variables 4 ideas
Format SQL 189 ideas
Intellisense 81 ideas
Platform Support 14 ideas
Qualify object names 6 ideas
Script object as alter 15 ideas
Smart rename 10 ideas
Summarize script 5 ideas
Tab coloring 6 ideas
Tab history 42 ideas
User interface 99 ideas

Searching…

No results.
Clear search results

- Flyway 17 ideas
- MySQL tools 24 ideas
- Oracle 128 ideas
- Redgate 0 ideas
- SQL Change Automation 51 ideas
- SQL Compare 263 ideas
- SQL Data Compare 116 ideas
- SQL Prompt 690 ideas
- SQL Search 135 ideas
- SQL Source Control 587 ideas
- SQL Toolbelt Essentials 30 ideas
Redgate

Indent statement after IF when not enclosed by BEGIN/END block

if blah=1
____return 1;

if blah=2
_begin
_return 2;
_end
else
_return 0;

14 votes

Jevon Anderson shared this idea · Mar 19, 2018 · Report… · Admin →

An error occurred while saving the comment

Lee Robinson commented · July 11, 2018 6:45 AM · Report

I would agree as long as "return 2" inside the BEGIN/END is also indented

Submitting...
Lee Robinson commented · March 20, 2018 4:14 PM · Report

I don't quite understand this. The example shows all statements after the IF indented whether or not enclosed in BEGIN/END block. I would vote for this if it stated that all statements after the IF should be indented.

Submitting...