Results 1 to 3 of 3

Thread: select from table - xml file

  1. 11-08-2005, 07:21 AM #1
    fcela
    fcela is offline Registered User
    Join Date
    Oct 2005
    Posts
    7

    select from table - xml file

    Hi. How I can do a query on datatype ntext (xml file) in "SQL Query Analyzer" when I need all data? When I get select from this table, I get back
    only first 256 bytes (chars)??? Thanks
    Reply With Quote Reply With Quote
  2. 11-08-2005, 08:56 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    click on TOOLS- OPTIONS- Results tab -
    change Maximum character per column to 8000
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 11-08-2005, 09:13 AM #3
    fcela
    fcela is offline Registered User
    Join Date
    Oct 2005
    Posts
    7
    Great! How easy!! Thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules