SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot Bruce Lee's Avatar
    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.

  2. #2
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorry, it can't be done.

    You can output the data using the bcp.exe utility, however, and then view it.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •