SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
-
Feb 1, 2005, 04:51 #1
- Join Date
- Jan 2005
- Location
- Singapore
- Posts
- 198
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Problem displaying the complete content in Query Analyzer
Hi ,
There is a Colmn with data type "ntext" with length 16 in a table.
when i select data for this column in Query Analyzer(QA), i can only see 256 characters cuz its default.
i can change this value to max 8192 char in options -> results.
but what if i want to see data more than 8192 char in QA?
I tried to save in text and export to excell /access but i can get only max 8192.
some times i need to check the whole big string and its tidious to call them in a front end page.
anyone knows how to solve this???Happy Coding!!!
Bruce Lee.
-
Feb 2, 2005, 14:29 #2
Sorry, it can't be done.
You can output the data using the bcp.exe utility, however, and then view it.
Bookmarks