How can we improve SQL Prompt?

Autoformat should not indent begin

Instead of

IF xxx
BEGIN
sss
sss
END

It should format as

IF xxxx
BEGIN
ssss
ssss
END

for all cases where begin and end are used.

40 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    hoganlonghoganlong shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • BlaiNBlaiN commented  ·   ·  Flag as inappropriate

        IndentBeginToken in config not changing anything (Beta 6.4).

        My stored procedure code has 2 indents because of the starting BEGIN. Don't like it that way, wasting space...

      • Mr.DiGiMr.DiGi commented  ·   ·  Flag as inappropriate

        Option is not in UI but we can modify it in:

        c:\Users\<your login>\AppData\Local\Red Gate\SQL Prompt 5\RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml

        Change element IndentBeginToken:

        <IndentBeginToken>False</IndentBeginToken>

      Feedback and Knowledge Base