Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rythn
Starting Member
2 Posts |
 Posted - 2012-09-22 : 11:07:05
|
Hey everybody,I'm having a problem with SQL Server Management Studio, as you can see below in the image, columns 1-3 are not showing the full column names. This happens when I right-click table name, and then click "Select Top 1000 Rows". I want it to show full column names. Please help me out, Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-09-22 : 11:32:03
|
| Don't use that option to run your queries. Click the new query button and type in your query, then hit execute or F5. To expand them automatically, you can view them in text mode. But that'll cause other issues like some will be too big. I typically start in grid mode and switch to text mode as needed. And if text mode is needed and I need to shrink it down, I then add some converts to the varchar columns to get them to the minimum size.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
rythn
Starting Member
2 Posts |
Posted - 2012-09-22 : 11:54:39
|
Unfortunately, the same problem happens in grid mode if I click the "new query" button and then execute a stored procedure / select statement. Text mode doesn't cut it for me, as it's harder to determine in which row is which value, since it doesn't have the borders. Thanks for your answer, but oh well, I guess I'l have to get used to seeing half column names.quote:
Originally posted by tkizer
Don't use that option to run your queries. Click the new query button and type in your query, then hit execute or F5. To expand them automatically, you can view them in text mode. But that'll cause other issues like some will be too big. I typically start in grid mode and switch to text mode as needed. And if text mode is needed and I need to shrink it down, I then add some converts to the varchar columns to get them to the minimum size.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-22 : 12:46:39
|
| you can always resize them as you want if needed. or copy result using copy with column headers option and paste it on an excel to see full resultsyou may even choose save as file option and save query results directly in file and view it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
Show Full Column Names on Results to Grid