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 |
|
SQLCode
Posting Yak Master
143 Posts |
 Posted - 2004-05-20 : 14:57:51
|
| Hi,I need to select from a table which has text datatype. It is truncating values after 255 characters. I thought I saw some similar post here, but can't find it now.Any ideas of how to retrieve the whole value?TIA |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-05-20 : 15:24:47
|
| Look up SET TEXTSIZE in BOLBut You'll also need to look at READTEXT, WRITETEXT, ect....Why are you using Text?Brett8-) |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-20 : 16:39:33
|
| Is this query analyser?Tools, options, results, max chars per column==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Text datatype data retrieval - urgent