Add option to wrap lines when concatenating strings
Sometimes I set a variable equal to many strings concatenated together using the "+" syntax. When I format with Regdate, there is no option to wrap lines in this case. Everything ends up on the same line as the SET, so the lines often get very wide and go off screen.
It would be great if there was an option to wrap text if things got too wide horizontally.
One solution would be a setting to format concatenated strings like this:
SET @Variable = N'String1'
+ N'String2'
+ N'String3'
Amanda
shared this idea
Hi Amanda,
Would the ‘wrap lines longer than X characters’ option in the formatting styles help with this?
Tim
-
-jim
commented
Amanda, if you end each line with an empty comment (--) then SQL prompt won't mess up your formatting. But it's sad that we have to use this workaround...
-
-jim
commented
I don't like the ‘wrap lines longer than X characters’ option. I want nice clear formatting so I like the '+' to always start on a new line, I'm sure I'm not alone in this. SQL prompt formatting just makes a mess of things in this case.