IF ... ELSE IF stairstepping...

chrisw13chrisw13 Posts: 6 Bronze 2
edited July 2, 2013 12:54PM in SQL Prompt Previous Versions
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

Comments

  • 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.
    Manfred Castro
    Product Support
    Red Gate Software
Sign In or Register to comment.