Web Development

General discussion


SQL query results

By gerald.duncan ·
Does anyone know of a SQL runtime parameter to automatically expand the results columns to the width of the largest value? I know the columns can be expanded manually, but this is VERY time consuming for queries returning many columns.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Nothing to do with SQL

by Tony Hopkinson In reply to SQL query results

That's in what ever component in what ever application being used to display the result.

Collapse -

Max width column setting

by gerald.duncan In reply to Nothing to do with SQL

OK, the application being used to run the queries is SQL Server Management Studio. Is there a setting inside it which permits this?

Thank you.

Collapse -

don't think so

by Shellbot In reply to Max width column setting

its really just a grid control..don't think there's anywhere you can tweak it

Collapse -

Not that I'm aware of

by Tony Hopkinson In reply to Max width column setting

I've done thgis sort of thing programatically in applications, it's very expensive even if you limit it to those values on display.

Proably the quickest way tio get what is to send the query result to a file and then look at that.

If you are doing a session of them.
Tools->Options->Query Results->SQL Server is where you want to look.

Related Discussions

Related Forums