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 |
|
jubilanttiger
Starting Member
19 Posts |
 Posted - 2005-05-26 : 13:30:12
|
| Hi,SQL Server 2000I am trying to retrieve "text" type data from the database to a .txt file. To start with, I tried to retrieve it through a select statement as,SELECT TextColumnFROM dbo.XMLTestTBLBut the data get truncated. Do you know of any way I can retrieve the text data in whole. I am actually trying to retrieve the data to a .txt file so that I can look into and debug the data error.If you can give me an example of solution it would be very helpful.Thanks for helping me overcome this roadblock !!! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-05-26 : 13:44:53
|
you just probably need to set the text length option to 8000.Query Analyzer->Tools->Options->Results->Maximum characters per column = 8000and that's it.Go with the flow & have fun! Else fight the flow  |
 |
|
|
jubilanttiger
Starting Member
19 Posts |
Posted - 2005-05-26 : 13:49:40
|
| But even then changing the "Maximum characters per column = 8000" wouldnt solve the problem, for the "TextColumn" column of my table is made up of data greater than 8000 characters long, hence the data would get truncated in the select statement... ??? |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-05-26 : 15:38:14
|
| Are you familiar with the TEXTPTR, READTEXT, UPDATETEXT, WRITETEXT, PATINDEX, DATALENGTH, and SET TEXTSIZE functions. They are a set of functions specifically designed to operate on text and image data types.See BOL for further information.HTH=================================================================The surest way to corrupt a youth is to instruct him to hold in higher esteem those who think alike than those who think differently. -Friedrich Nietzsche, philosopher (1844-1900) |
|
|
|
|
|
|
|
|
Retrieve "Text" Data from a SQL Server