How to see the complete data that exists in a column (data type defined as a text) in query analyzer

Question

Post reply

How to see the complete data that exists in a column (data type defined as a text) in query analyzer

gsd1

Default port

Points: 1442
More actions
October 15, 2012 at 8:01 am

#269513

Hello friends,
There is a big xml string in a column (data type defined as a text)
When I query in query analyzer, (after setting Tools--> options-->Query Results --> SqlServer --> Resulsts to Grid --> XML data --> UNLIMITED)
I couldn't get to see complete xml string.
How can I see this data?
Thanks & Regards,

Viewing 7 posts - 1 through 6 (of 6 total)

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

You can't see it in SSMS. The most it will return is 65k. If you need more text you need to use another application.

--edit--

Just realized you are asking about xml results....I don't know about the xml results.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Scott D. Jacobson SSCertifiable Points: 6149 More actions · Answer 2

How about exporting the column to a file using SSIS or the Import/Export Wizard?

gsd1 Default port Points: 1442 More actions · Answer 3

Scott D. Jacobson, your advice worked.....Thank you.

Scott D. Jacobson SSCertifiable Points: 6149 More actions · Answer 4

Scott D. Jacobson

SSCertifiable

Points: 6149

October 15, 2012 at 9:47 am

#1549180

You are very welcome. Gald I could be of help.

Jeff Moden SSC Guru Points: 1004407 More actions · Answer 5

BWAA-HAAA!!! I solved that problem long ago.... I don't let people put XML in databases that I have a say so on. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Sean Lange SSC Guru Points: 286590 More actions · Answer 6

Jeff Moden (10/15/2012)
BWAA-HAAA!!! I solved that problem long ago.... I don't let people put XML in databases that I have a say so on. 😉

+1

That is why I have no idea how to view more than 5MB of data in a single column. :w00t:

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/