How can I read the whole data from start to finish in a column of "Text" datatype?

Question

How can I read the whole data from start to finish in a column of "Text" datatype?

rames.net

SSC-Addicted

Points: 468
More actions
August 26, 2009 at 5:02 am

#225419

We have a column with a "Text" datatype in a SQL Server 2000 table.
How can I read the whole data from start to finish in a column of "Text" datatype?
It seems that while reading the data using "Select" statements it fetches only partial data.
Please help.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

matt6288 SSCertifiable Points: 5058 More actions · Answer 1

I don't have the SQL 2000 available anymore but I think you can change the number of characters displayed in the tools menu. You can try the "results to text" and the check in the options to see where you can change the number of characters.

joeroshan SSChampion Points: 10377 More actions · Answer 2

Do you have this problem in query analyzer?

I if understood your problem correctly its limitation in output display only.

You might want to change the default setting in

tools> options>results>maximum characters per column

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

rames.net SSC-Addicted Points: 468 More actions · Answer 3

THANKS FOR ur reply.

is there any other method is there to retirve data by using query.

Lowell SSC Guru Points: 323518 More actions · Answer 4

if you are using SQL2505, you can convert the TEXT to varchar(max), but if you try and view the results in SSMS, you will still have the same issue identified by other posters: QA and SSMS default to showing the first 256 chars, and you can increase it to 8000 chars.

any ADODB.Recordset or Datatable you use in your application will receive the complete field, but in a development environment, the tools I mentioned will not display the whole thing;

here's where is SSMS you'd change to make sure you see more of the field: QA has a similar screen.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!