Replace all inline comments with block comments
It would be really useful to be able to choose the default comment style as either inline -- or comment block /* */, and have that style be applied when executing an auto-format on the script.
See https://www.erikdarlingdata.com/sql-server/please-use-block-quotes-for-code-comments-in-your-t-sql/ for more info
-
Jim Nguyen commented
I would like the reverse option as well. While I can understand the argument for always using block comments, similar arguments can be made for inline commenting. Ultimately, using one style of commenting is not always convenient in every scenario.
-
Justin B. commented
Brent Ozar seconded this thought:
https://www.brentozar.com/archive/2021/04/never-ever-ever-start-t-sql-comments-with-two-dashes/