How can we help you today? How can we help you today?

Collapsed formatting question

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');
RTSJohn
0

Comments

2 comments

Sort by
  • ATurner
    Hi RTSJohn

    I believe that currently is the only way to have each one on a separate line. I am just going to double check this.
    ATurner
    0
  • ATurner
    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
    ATurner
    0

Add comment

Please sign in to leave a comment.