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 |
|
comein
Starting Member
1 Post |
 Posted - 2002-01-21 : 22:53:18
|
| My NEWS table have a long text field name CONTENT which larger than 4K . When I use statement " SELECT CONTENT FROM NEWS " , just a part of CONTENT is returned. How can I retrieve this fields completely ? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-01-21 : 22:58:19
|
| In Query Analyzer, look for the Connection Options menu, one of the tabs (I forget which) has a setting for maximum characters to display. It defaults to 255 or 256, just increase it to the number you want. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-01-21 : 22:58:54
|
| You can use substring on the text field to retrieve 4k at a time.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Question