Collapsed formatting question
RTSJohn
Posts: 7 Bronze 1
How can I get the below sample to collapse all the state entries to use the least number of lines yet still wordwrap? All I'm able to get right now is one state per line no matter what I do with the formatting controls.
CREATE TABLE #States (STATE VARCHAR(3) NOT NULL); INSERT INTO #States(STATE) VALUES('AK'), ('AL'), ('AR'), ('AS'), ('AZ'), ('CA'), ('CO'), ('CT'), ('DC'), ('DE'), ('FL'), ('GA'), ('GU'), ('HI'), ('IA'), ('ID'), ('IL'), ('IN'), ('KS'), ('KY'), ('LA'), ('MA'), ('MD'), ('ME'), ('MI'), ('MN'), ('MO'), ('MP'), ('MS'), ('MT'), ('NC'), ('ND'), ('NE'), ('NH'), ('NJ'), ('NM'), ('NV'), ('NY'), ('OH'), ('OK'), ('OR'), ('PA'), ('PR'), ('RI'), ('SC'), ('SD'), ('TN'), ('TX'), ('UM'), ('UT'), ('VA'), ('VI'), ('VT'), ('WA'), ('WI'), ('WV'), ('WY');
CREATE TABLE #States (STATE VARCHAR(3) NOT NULL); INSERT INTO #States(STATE) VALUES('AK'), ('AL'), ('AR'), ('AS'), ('AZ'), ('CA'), ('CO'), ('CT'), ('DC'), ('DE'), ('FL'), ('GA'), ('GU'), ('HI'), ('IA'), ('ID'), ('IL'), ('IN'), ('KS'), ('KY'), ('LA'), ('MA'), ('MD'), ('ME'), ('MI'), ('MN'), ('MO'), ('MP'), ('MS'), ('MT'), ('NC'), ('ND'), ('NE'), ('NH'), ('NJ'), ('NM'), ('NV'), ('NY'), ('OH'), ('OK'), ('OR'), ('PA'), ('PR'), ('RI'), ('SC'), ('SD'), ('TN'), ('TX'), ('UM'), ('UT'), ('VA'), ('VI'), ('VT'), ('WA'), ('WI'), ('WV'), ('WY');
Tagged:
Best Answer
-
ATurner
Posts: 204 Silver 2
Hi RTSJohn
This kind of functionality is not currently in SQL prompt, would suggest submitting this to the user voice forum https://redgate.uservoice.com/forums/94413-sql-prompt
Answers
I believe that currently is the only way to have each one on a separate line. I am just going to double check this.