SP : Returned and Passing XML

• Ronsi-384491

  SSC-Addicted

  Points: 475

  More actions

  May 10, 2007 at 3:27 am

  #178494

  Hi..

  How to create SP that returned XML? and passing the XML to another SP ?

  is it possible ? in SQL Server 2005 ?

• Anders Pedersen

  SSChampion

  Points: 11410

  More actions

  May 10, 2007 at 6:31 am

  #705465

  You can use a variable with XML data type to pass XML into another stored procedure.

• Ronsi-384491

  SSC-Addicted

  Points: 475

  More actions

  May 11, 2007 at 4:08 am

  #705754

  ah.. ok.. thanks