Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to see the complete data that exists in a column (data type defined as a text) in query analyzer Expand / Collapse
Author
Message
Posted Monday, October 15, 2012 8:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 29, 2014 10:05 AM
Points: 34, Visits: 90
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,
Post #1372742
Posted Monday, October 15, 2012 8:18 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:16 PM
Points: 13,268, Visits: 12,097
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1372753
Posted Monday, October 15, 2012 9:28 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 1:20 AM
Points: 359, Visits: 907
How about exporting the column to a file using SSIS or the Import/Export Wizard?
Post #1372778
Posted Monday, October 15, 2012 9:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 29, 2014 10:05 AM
Points: 34, Visits: 90

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

Post #1372784
Posted Monday, October 15, 2012 9:47 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 1:20 AM
Points: 359, Visits: 907
You are very welcome. Gald I could be of help.
Post #1372787
Posted Monday, October 15, 2012 12:18 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:17 AM
Points: 36,944, Visits: 31,448
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1372875
Posted Monday, October 15, 2012 12:38 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:16 PM
Points: 13,268, Visits: 12,097
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.


_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1372893
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse