Post reply

FOR XML Clause

  • March 29, 2005 at 9:16 am

    #164897

    Hello All, I hope that everyone is having a fine day.

    I am performing a SELECT Statement using the FOR XML clause, however, my data that is returned is not showing like it does in the BOL. I am using query analyzer. Is there a setting in QA that I should set? I have tried returning in all three views. Still the same, and it is not returning all rows. Seems to cut the data short. This is my query:

    select proc_dt, acc_ama_tdt, acc_exp_tdt from ttg_intr_position_exp

    FOR XML AUTO, ELEMENTS

    This is my results:

    Mar 25 2005 12:00AM0.00682986.11Mar 25 2005 12:00AM0.00

  • March 29, 2005 at 11:16 am

    #549376

    You can try increasing the number of characters per column displayed in query analyzer.  Go to Tools -> Options -> Results.

    Hope this helps.

     

  • March 29, 2005 at 11:27 am

    #549378

    Mine is currently set to 8192, the max that QA can have.

    Thanks

    Andrew SQLDBA

  • March 30, 2005 at 7:21 am

    #549532

    Dbcc traceon(257)

    For the session...this will format the results for QA screen.

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

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