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 |
|
jotmenow
Starting Member
12 Posts |
 Posted - 2006-10-10 : 10:37:44
|
| Dear allI have got a table loaded with a lot of text into the database properly.but when i execute a select command it does not pick the entire text.Most of it is truncated.Can any one helpme in this regard.Thanksajay. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-10 : 10:39:07
|
| It's probably the client that is doing the truncation.It will be client dependent - if it's in query analyser then you have to set the character limit for the result - max 8000.==========================================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. |
 |
|
|
jotmenow
Starting Member
12 Posts |
Posted - 2006-10-10 : 10:43:30
|
| How can i set the character limit for the result - max 8000.Thanks in advanceAjay. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-10 : 11:00:58
|
quote:
Originally posted by jotmenow
How can i set the character limit for the result - max 8000.
Assuming you are using Query Analyzer, go to Tools-->Options menu. Click results tab and change the value for 'Maximum Characters per Column'.-ec |
|
|
|
|
|
|
Data from a text colum getting truncated