IF ... ELSE IF stairstepping...

chrisw13

IF ... ELSE IF statements are indented, which is technically accurate, but not conducive to code flow. It would be nice if the IF was placed on the same line as the ELSE and the following line not indented further...

Example:

DECLARE @check INT

IF @check = 1
    SELECT  1
ELSE
    IF @check = 2
        SELECT  2
    ELSE
        IF @check = 3
            SELECT  3
        ELSE
            IF @check = 4
                SELECT  4

Better formatting:

DECLARE @check INT

IF @check = 1
    SELECT  1
ELSE IF @check = 2
    SELECT  2
ELSE IF @check = 3
    SELECT  3
ELSE IF @check = 4
    SELECT 4

Running SqlPrompt 6.0.0.71 EAP

Manfred.Castro

This would be considered a formatting feature request.
You can direct feature requests to our uservoice forums.
http://redgate.uservoice.com/forums/944 ... uggestions
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.