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 |
|
Jgries
Starting Member
17 Posts |
 Posted - 2011-11-21 : 12:58:16
|
| Hello,I'm attempting to export data from a query I'm running. The query appears to be fine, but upon selecting 'Results to file' and then opening, the field needed seems to truncate around 240 characters and I'm not sure why. The field is very large, set to varchar(max) as it is a large data dump. Is there a way to capture all the text for the field without the truncation? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-21 : 13:11:58
|
| check what value you've given for maximum characters to be displayed in Tools->Options-> Query Results------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Jgries
Starting Member
17 Posts |
Posted - 2011-11-21 : 13:27:52
|
| Thanks, but that doesn't seem to be the issue. I don't believe its my query, but I've included it in case if you have any idea. Thanks for your help.SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT P.ProjectName, P.ProjectCity, P.ProjectState, [ArchName] = (SELECT CompanyName + ', ' FROM dbo.Company AS C WHERE C.ProjectID = P.ProjectID FOR XML PATH('')), DT.DocumentText FROM dbo.DocumentText AS DT JOIN dbo.DocumentProperty AS DP ON DT.DocumentPropertyID = DP.DocumentPropertyID JOIN dbo.Project AS P ON DP.ProjectID = P.ProjectID |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-22 : 00:55:29
|
| which field is having large data in it? also is it full query or do you have another part linked to this using union all or something?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Data Truncation Upon Export