← Customer Feedback for Devart Settings and activity 2 results found Separate (one-line) format for simple "when then else end" statement 4 votes Vote Vote Vote Vote We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close 1 vote 2 votes 3 votes Remove votes You have left! (?) (thinking…) 1 comment · SQL Complete · Delete… · Admin → How important is this to you? Not at all You must login first! Important You must login first! Critical You must login first! We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close An error occurred while saving the comment Damien Schoof commented · Dec 3, 2014 · Edit… · Delete… I would like to extend this to cover a few more cases as well. E.g. if I have an if statement: IF NOT EXISTS (SELECT * FROM myTable WHERE MyID = 3) BEGIN /* Do stufff */ END I would like the SELECT statement here to stay on one line unless it is too long. Save Submitting... Damien Schoof supported this idea · Dec 3, 2014 "Folding" queries 28 votes Vote Vote Vote Vote We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close 1 vote 2 votes 3 votes Remove votes You have left! (?) (thinking…) 1 comment · SQL Complete · Delete… · Admin → How important is this to you? Not at all You must login first! Important You must login first! Critical You must login first! We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close Damien Schoof supported this idea · Dec 3, 2014
I would like to extend this to cover a few more cases as well.
E.g. if I have an if statement:
IF NOT EXISTS (SELECT * FROM myTable WHERE MyID = 3)
BEGIN
/* Do stufff */
END
I would like the SELECT statement here to stay on one line unless it is too long.