Format SQL query results

Question

I am looking for a way to set the width on the returned column result from a SQL query.

I run a query like Select Product from ConfigScheduling where Product is an Nvarchar(Max) column. The result in SQL Server Management Studio with Results to Grid is a 90 char wide visible column, with the full result present, but not visible.

Thank you

JeffO · Accepted Answer · 2009-02-17 15:20:22Z

2

Couldn't find it by default, but if you double-click on the right part of the Column Header it will stretch like in Excel.

answered Feb 17, 2009 at 15:20

JeffO

8,1233 gold badges46 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Taylor Gerring · Accepted Answer · 2009-02-17 23:10:00Z

2

Tools>Options>Query Results>SQL Server>Results to Grid>Non XML data Tools>Options>Query Results>SQL Server>Results to Text>Maximum number of characters displayed in each column.

If these still don't suit your needs, you'll need to use another tool such as bcp or sqlcmd/osql.

answered Feb 17, 2009 at 23:10

Taylor Gerring

1,8351 gold badge12 silver badges17 bronze badges

Comments

achinda99 · Accepted Answer · 2009-02-17 15:06:58Z

1

If I remember correctly, SQL Server Management Studio cannot pull the whole nvarchar(max) field into display and won't attempt to either. The only way to fully access the resultset is to use a third party tool or display it in a gridview or something in a webapp.

answered Feb 17, 2009 at 15:06

achinda99

5,0784 gold badges37 silver badges42 bronze badges

1 Comment

Joel MC Over a year ago

Results to text file gives the entire results.

Collectives™ on Stack Overflow

Format SQL query results

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related