Be able to add space between two right parentheses
When I have two right parentheses next to each other like in a query like this (in the OPTION clause)
INNER JOIN TableB
ON TableA.Key = TableB.Key
OPTION( USE HINT( N'FORCEDEFAULTCARDINALITY_ESTIMATION' ) )
There doesn't appear to be an option to have the space between the two right parentheses at the end. I have tried checking/unchecking quite a few boxes in the formatting style editor, and I don't think anything is controlling this. To me, the "add spaces around parentheses contents" option should put a space between the two right parentheses, but it doesn't.
Thanks for reporting this. The team have reviewed the suggestion and we think it’s a bug rather than a feature suggestion.
If you’d like to submit this as a ticket into our support team we’ll pick it up from there and action.