What are the challenges you face when working across database platforms? Take the survey
Options

How to put the OPTION clause on a separate line?

ogrishmanogrishman Posts: 81 Bronze 4
edited November 18, 2016 5:16AM in SQL Prompt
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'[A-G]%'
 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.

Comments

  • Options
    Aaron LAaron L Posts: 596 New member
    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.
Sign In or Register to comment.