How to put the OPTION clause on a separate line?

Hi guys,

I have the following query:

SELECT
    p.Name,
    Total = SUM(inv.Quantity)
  FROM
    Production.Product AS p
    INNER JOIN Production.ProductInventory AS inv
        ON inv.ProductID = p.ProductID
 WHERE p.Name LIKE N'&#91;A-G&#93;%'
 GROUP BY p.Name OPTION(RECOMPILE, QUERYTRACEON 8605);

Is it possible to format it and put OPTION clause on a separate line? I tried but can't find an option to control this behavior. Is it possible?

Thanks.

ogrishman November 18, 2016 02:19

Comments

1 comment

Hi ogrishman,

Thanks for your post! In the 7.3 beta formatter there's currently no setting to put the OPTION clause on a new line. We'll look into improving this and I'll let you know when we have a new build out with it in.

Thanks,
Aaron.

Aaron L November 18, 2016 05:16

0

Add comment

Please sign in to leave a comment.

How can we help you today?

How to put the OPTION clause on a separate line?

Comments

Add comment