Post reply

For XML Explicit

  • May 19, 2006 at 9:49 am

    #67435

    Hi all,

    I am trying to create a XML from a select statment using the clause "For XML Explicit" and I encounter a problem.  The output gets truncated to 248 characters. How can I avoid this to happend?  My result should be at least 700 characters.

    Thanks,

    Donald

  • May 19, 2006 at 1:56 pm

    #639086

    I'm guessing you're running this in Query Analyzer.

    Your actual output is the full length, but QA is cutting it off.  From the menu, choose Tools -> Options and look for the setting that limits the size of the results, which by default will be set to 255.  Crank that value up a bit and you should be fine.

     

    -Eddie

    Eddie Wuerch
    MCM: SQL

  • May 19, 2006 at 2:26 pm

    #639090

    Thanks Eddie. That was it.

    Donald

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply