create xml file from tables for web services

• andrew.fong

  Newbie

  Points: 1

  More actions

  May 27, 2008 at 3:32 pm

  #380730

  Hi,

  I am pretty new to XML and webservices. Basically I have a table that is loaded every few hours by a DTS package. After each load, I want to create an XML to be sent through webservices. How do I write a stored procedure to convert the contents of the table into XML?

  Any help would be greatly appreciated.

  Thanks

  Andrew

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  May 27, 2008 at 4:00 pm

  #820870

  to get you started:

  select * from tablename for xml auto

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]