SQL Prompt Styles - Can you add a blank line BEFORE statements?

Reggie

I do like the options when it comes to creating your own styles but I just can't quite get it the way I want.

The closest I get is...

SELECT
DatabaseName,
SchemaName,
ObjectName,
ObjectType,
IndexName,
IndexType,
Command,
CommandType,
StartTime,
EndTime,
ErrorNumber,
ErrorMessage
FROM
dbo.CommandLog
WHERE
ErrorNumber > 0;

But what I really want is a single blank line before statements...

SELECT
DatabaseName,
SchemaName,
ObjectName,
ObjectType,
IndexName,
IndexType,
Command,
CommandType,
StartTime,
EndTime,
ErrorNumber,
ErrorMessage

FROM
dbo.CommandLog

WHERE
ErrorNumber > 0;

Just want to make sure I'm not missing the option somewhere before submitting a suggestion.

Thanks

Robyn

Hi Reggie. 

I'm going to raise a support ticket for you where I'll ask if you could provide your formate style file? 

I think, what your looking for will need to be added as a feature request, but we'd like to give a few options a try first to be sure!

Reggie

Robyn said:

Hi Reggie. 

I'm going to raise a support ticket for you where I'll ask if you could provide your formate style file? 

I think, what your looking for will need to be added as a feature request, but we'd like to give a few options a try first to be sure!

Thanks Robyn!  I've shared my style file with the ticket that you created.

PeterDongadee

Reggie and I must have the same formatting tastes. I vote strongly for the ability to include a line before a statement, where there are multiple items in the statement.