Results 1 to 2 of 2
Feb 1, 2005, 03:51 #1
- Join Date
- Jan 2005
- 0 Post(s)
- 0 Thread(s)
Problem displaying the complete content in Query Analyzer
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!!!
Feb 2, 2005, 13:29 #2
Sorry, it can't be done.
You can output the data using the bcp.exe utility, however, and then view it.