On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.

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

ReggieReggie Posts: 4 New member
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

Answers

  • 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!
    Kind regards

    Robyn Edwards | Redgate Software
    Have you visited our Help Center?
  • ReggieReggie Posts: 4 New member
    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.
  • PeterDongadeePeterDongadee Posts: 1 New member
    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.

Sign In or Register to comment.