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

Alignment

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
0

Comments

4 comments

Sort by
  • torsten.strauss
    SQL Prompt Version 9.4.6.7396


    torsten.strauss
    0
  • Russell D
    Same with this one.


    I take it you want the 'querytraceon' line lined up with the above bracket?
    Russell D
    0
  • 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
    torsten.strauss
    0
  • 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!
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.