Convert SQL Table to XML...

• Vincy-856784

  Ten Centuries

  Points: 1298

  More actions

  July 21, 2010 at 6:06 am

  #235523

  Hello All,

  I have a table with the following structure with full of data:

  CREATE TABLE errorLog(

  [ID] [int] IDENTITY(1,1) NOT NULL,

  [params] [varchar](max) NULL,

  [vals] [varchar](max) NULL

  )

  I suppose, SQL Server 2008 supports XML widely and I am wondering whether i can convert the above table data to xml with the table structure easily and automatically.

  So, the XML representation would look something like this:

  <errorLog>

  <ID>1</ID>

  <ID>params</ID>

  <ID>vals</ID>

  </errorLog>

  Any help or suggestions are greatly appreciated.

• Dwayne Dibley

  SSCrazy

  Points: 2350

  More actions

  July 21, 2010 at 6:14 am

  #1196095

  If you want to select the data and convert it to XML, you need to look at the FOR XML clause. Check out thisMSDN link.

• Vincy-856784

  Ten Centuries

  Points: 1298

  More actions

  July 21, 2010 at 7:10 am

  #1196137

  Thank you for your quick response. That should do it.:-)

• shannya007

  SSC Rookie

  Points: 37

  More actions

  October 26, 2012 at 12:11 am

  #1553046

  please send how to convert sql table convert to xml files??/