FOR XML Clause

• Andrew Liles

  Mr or Mrs. 500

  Points: 520

  More actions

  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

• Amy Sommer

  SSC-Addicted

  Points: 485

  More actions

  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.

   

• Andrew Liles

  Mr or Mrs. 500

  Points: 520

  More actions

  March 29, 2005 at 11:27 am

  #549378

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

  Thanks

  Andrew SQLDBA

• michanne

  SSCrazy

  Points: 2329

  More actions

  March 30, 2005 at 7:21 am

  #549532

  Dbcc traceon(257)

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