parenthesis

torsten.strauss

Hi!

I am wondering if the formatting of the following statement is intended:

IF EXISTS (
			SELECT * FROM sys.server_event_sessions WHERE name = 'Waits'
	)
	DROP EVENT SESSION Waits ON SERVER;
GO

I am not able to align the parenthesis in a better way ...

Thanks!

BTW. Maybe I do not know how but it would be nice to get better formatting options in the post to suggest the formatting. Using tabs or spaces here will not lead to the expected format (at least for me)

Torsten
Friend of Redgate

Russell D

Hi Torsten,

Can you confirm which style you are using in Prompt (if not a custom style), and what version of Prompt/SSMS?

torsten.strauss

Hi Russell,

thanks for looking into this.
Version : 8.0.0.1241

I guess the reason for miss formatting is caused by setting Parentheses/ Parentheses contents/ Place on new line / Indent parentheses contents (enabled)

Hope this helps!

Otherwise I need to send you my custom style.

Russell D

Could you please send your custom style into support? It would help me a lot.

James R

Hi @torsten.strauss !

Thanks for reporting this, it seems to be an issue when you collapse 'Short DML statements' and 'Short Subqueries' at the same time. We have a fix for it here and will hopefully have it released in the next few days.

Thanks!

torsten.strauss

Thanks James!