OPTION
Hi!
Would be good to control the formatting of the OPTION clause.
I personally prefer to have it on a new line
SELECT
*
FROM
Production.Product p
LEFT JOIN
Production.ProductSubcategory s
ON
p.ProductSubcategoryID = s.ProductSubcategoryID
WHERE
p.ProductSubcategoryID = 14 OPTION(QUERYTRACEON 8757);
GO
--should look like
SELECT
*
FROM
Production.Product p
LEFT JOIN
Production.ProductSubcategory s
ON
p.ProductSubcategoryID = s.ProductSubcategoryID
WHERE
p.ProductSubcategoryID = 14
OPTION(QUERYTRACEON 8757);
GO
Thanks!
This feature was released in version 8 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team
-
Torsten commented
Hi Aaron,
sorry for that - seems to be the default now...
-
Torsten commented
Hi Aaron,
I am not able to see the option.
Can you please guide me - thanks!