Format multi-line sql queries to single line queries
I had a requirement to change multi-line sql queries to single line queries.
UPDATE table_name
SET
column1=value
WHERE
condition=value1
AND condition2=value1;
UPDATE table_name
SET
column1=value2
WHERE
condition=value2
AND condition2=value2;
to
UPDATE table_name SET column1=value WHERE condition=value1 AND condition2=value2;
UPDATE table_name SET column1=value2 WHERE condition=value2 AND condition2=value2;
I have tried different sql formatter in VS Code and Notepad++, all formatting into multiple lines.
Then I came to below stackoverflow link and achieved single line format in in two steps.
Step 1: replace all (?:\h*\R\h*)+ with space
Step 2: replace all ; with ;\r\n
References
https://stackoverflow.com/questions/52003347/notepad-turn-big-query-from-sql-server-into-one-line