Discussion Locked

SQL query results

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

TIA

4 replies

by gerald.duncan

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.

by tony hopkinson

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.

This discussion is closed to new replies.