Compact Fomatting

Hello,

In SQL Prompt, I was wondering if you might be so kind as to consider providing some custom formatting like below

I quite often have SQL sent to me butchered up and it's such a pain to re-format it. I like the very condensed/compact format like in the example way below. Notice nothing is aligned, it's simply tight and compact, with a single tab for nested statements.

Thoughts?
Thanks,
Paul

/*Start with a terribly formatted piece of SQL like this*/
   SELECT TOP 200 
   A.Col1
   ,A.Col2
   ,A.Col3
   ,A.Col4
   ,A.Col5
   ,A.Col6,
A.Col7,
A.Col8
,A.Col9
	FROM FSS.dbo.Table_1 A
WHERE 
EXISTS (	SELECT 1
	FROM 
	FSS.dbo.Table_2 B 
	WHERE 
	A.Col9 = B.Col3 AND 
		A.Col6 = B.Col6
)
ORDER BY A.Col1,
A.Col2


/*Click Format Something and have the SQL look exactly like this. Maybe call it "Clean & Compact Formatting":*/
SELECT TOP 200 A.Col1,A.Col2,A.Col3,A.Col4,A.Col5,A.Col6,
A.Col7,A.Col8,A.Col9
FROM FSS.dbo.Table_1 A
WHERE exists (
	SELECT 1
	FROM FSS.dbo.Table_2 B 
	WHERE A.Col9 = B.Col3 AND A.Col6 = B.Col6
)
ORDER BY A.Col1,A.Col2

pbukowski August 31, 2016 15:50

Comments

3 comments

Hi

Weâ€™ve recently released a SQL Prompt beta with a more powerful formatting system which will enable you to format SQL in your suggested style. You can download it from here.

If you have any trouble configuring your suggested style, please let me know.

Thanks
Ali

Ali D September 01, 2016 05:50

0

Awesome - I just downloaded and tried it out. I was able to automatically format the mess above to this:

SELECT TOP 200 A.Col1, A.Col2, A.Col3, A.Col4, A.Col5, A.Col6, A.Col7,
A.Col8, A.Col9
FROM FSS.dbo.Table_1 A
WHERE EXISTS (
	SELECT 1
	FROM FSS.dbo.Table_2 B
	WHERE A.Col9 = B.Col3 AND A.Col6 = B.Col6
)
ORDER BY A.Col1, A.Col2

How can we help you today?

Compact Fomatting

Comments

Add comment