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 |
|
SemoneCOM
Starting Member
4 Posts |
 Posted - 2009-12-22 : 13:47:20
|
| I have a View that I created, this view creates several columns that has long string. This string is created to be Fixed column length to be used in .txt files. This view is being accessed by a reporting tool, that allows me to export to excel or word. But at the end of the columns are being truncated.columns look like this (they are longer:S555555555DOE JOE L12251959 000245645At the end of each of the columns when viewing the results in text pane or sending results to a file, the last part of the column is being truncated.I have done the following:len(column) = 276Select @@TextSize from MyView = 21474836473 I have tried SET TEXTSIZE to like 10000000000 but I get a incorrect syntax errorAny help as to how I can see all of the data in columnsThanks |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-12-22 : 14:00:44
|
| As far as viewing the result, in SSMS go to Tools\Options\QueryResults\ResultsToText and change to "Maximim Number of characters displayed in each column" to whatver you need it to be (max 8192). Not sure how to fix the export yet.JimEveryday I learn something that somebody else already knew |
 |
|
|
SemoneCOM
Starting Member
4 Posts |
Posted - 2009-12-22 : 15:18:53
|
| Thanks for the quick response Jim, I changed the characters displayed to 8192. And its still not showing.Thanks |
|
|
|
SemoneCOM
Starting Member
4 Posts |
Posted - 2009-12-22 : 15:22:57
|
| Sorry Jim, it does work. I had to close the windows and open a new one.Thanks |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-12-22 : 15:24:52
|
Oh yeah, don't forget to open a new window! JimEveryday I learn something that somebody else already knew |
|
|
|
SemoneCOM
Starting Member
4 Posts |
Posted - 2009-12-22 : 15:29:05
|
| IF I could get this to happen in the view where the external application will increase the column size that would be great.Thanks |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-12-22 : 17:18:14
|
| The external app can't change the column size of the view. You could alter the underlying table column to be varchar(max), so that it can accept large inputs from apps. Also, there will be a difference between what you can see in the window when you select from the view, and what an app would see if it selected from the view. All the data would be returned the app, providing the app could accept it.JimEveryday I learn something that somebody else already knew |
|
|
|
|
|
|
Data is trunc in some columns in text result pane