How can we help you today? How can we help you today?

IF ... ELSE IF stairstepping...

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
Chris Williamson
0

Comments

1 comment

Sort by
  • 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.
    Manfred.Castro
    0

Add comment

Please sign in to leave a comment.