I had formatting set for DML to be like:
INSERT into #temp(a, b, c)
SELECT A, B, C
FROM TableX
WHERE A = 'abc'
notice that I indent the from and the where 2 spaces from the alignment. If I set clause alignment to "to statement" and set clause indention to 2... it is kind of close but it doesn't seem to take inserts into account... so the select, from, where after the insert all align to the insert, not the select.
INSERT into #temp(a, b, c)
SELECT A, B, C
FROM TableX
WHERE A = 'abc'
Any assistance? This will start to cause issues as every time that I edit existing code and reformat, it will trigger a huge number of changed lines if we compare version in version control history.
INSERT into #temp(a, b, c) SELECT A, B, C FROM TableX WHERE A = 'abc'notice that I indent the from and the where 2 spaces from the alignment. If I set clause alignment to "to statement" and set clause indention to 2... it is kind of close but it doesn't seem to take inserts into account... so the select, from, where after the insert all align to the insert, not the select.
Any assistance? This will start to cause issues as every time that I edit existing code and reformat, it will trigger a huge number of changed lines if we compare version in version control history.