How to prevent formatting certain lines

DennisR

Is it possible to tell the formatter NOT to format a line (or section) - possibly by using a specific comment?

Michael Clark

Hi DennisR,

Yes that is possible with our new formatting styles.

You can turn these on by selecting "SQL Prompt > Options... > Labs > Experimental Features > Use new formatting styles". When we release the next major version, this will be on by default.

-- SQL Prompt formatting off
SELECT 1
-- SQL Prompt formatting on

Best wishes,

Michael Clark
Technical Lead, SQL Prompt

DennisR

Thanks. But it would be nice if there was a special comment to turn it off for just one line
E.g.

SELECT 1 --xf


(P.S. I do like the Labs new formatting styles and editor