How can we help you today? How can we help you today?

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

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
Reggie
0

Comments

3 comments

Sort by
  • 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!
    Robyn
    0
  • 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.
    Reggie
    0
  • 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.

    PeterDongadee
    0

Add comment

Please sign in to leave a comment.