Support dynamic formatting using @SQLComplete tag to override a setting
There may be times when you would like to switch the formatting for a particular section of code because the global settings would not be most appropriate.
For example let's stay in SELECT statements you have "Stack Columns" checked with "Simple List" selected. This may be the desired format for 90% of the cases, however when there is a table with a large number of columns(50+), it could be more beneficial to view them on a single line so to see the query as a whole.
If you could add a comment before the query
--@Begin-SQLComplete Select-SelectList-StackColumns = True; Select-SelectList-StackColumns-Option=SingleLine @End-SQLComplete
SELECT col1, col2, etc.
...
--@SQLCompleteTag Select-SelectList-StackColumns = Default; Select-SelectList-StackColumns-Option=Default
Doing this could allow the coder to have more fine tuning over the cases that are rare without the need to clutter the long list of formatting options currently in place.
Right now we have --no format and --endnoformat but in these cases we loose the benefits SQLComplete's formatting engine.
-
AdminDevart (_, Devart) commented
Hi,
Thanks for your patience!
Just want to inform you that it is already implemented - you need just Right-click on a piece of code.
So we would like to suggest updating to the latest version and check there.
Best,
Devart Support Team