Alignment

torsten.strauss

Hi Redgate Team,

The following code is formatted like this

[code]

SELECT *
FROM
    dbo.test_statistics
WHERE
    col1 = 101
OPTION (QUERYTRACEON 9481 -- Redirects the output to SSMS
                   , QUERYTRACEON 3604, QUERYTRACEON 9204 -- Returns the Statistics that were used during Cardinality Estimation
       );
GO

[/code]

There is no way to adjust the alignment of the second line in the subquery.

Thanks for your support!

Torsten

MVP

torsten.strauss

SQL Prompt Version 9.4.6.7396

Russell D

Same with this one.


I take it you want the 'querytraceon' line lined up with the above bracket?

torsten.strauss

You are right Russell , querytraceon should be aligned with the one above. 
It seems the issue is maybe caused by tge comments ... 
Thanks for looking into this  

Tianjiao_Li

@torsten.strauss

You are right, this is unfortunately not possible to do with Prompt at the moment. I couldn't find any similar suggestion on our user voice forum. Can you kindly post it there? https://redgate.uservoice.com/forums/94413-sql-prompt 

Thanks!