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.
18
votes
hoganlong
shared this idea
This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
BlaiN
commented
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.DiGi
commented
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>
-
Paul Nuttall
commented
I always indent BEGIN END by 3 spaces
The code left aligns with the begin