How to insert xml data into table

• avdhut.k

  SSCrazy

  Points: 2834

  More actions

  January 16, 2014 at 12:22 am

  #281248

  Hi,

  My requirement is to insert the xml data generated into a table,

  following is the sample code,

  Create table #testfiles

  (

  filemeta varchar(1000)

  )

  Insert into #testfiles

  select 1 as a, 2 as b for xml raw

  I am Using Sql server 2008R2.

  Please help me,I need this urgently.

  Thanks in advance!!

• Kenny Jozi

  SSCrazy

  Points: 2028

  More actions

  January 16, 2014 at 12:41 am

  #1680531

  check out this link

  http://stackoverflow.com/questions/4758992/how-to-insert-xml-data-into-table-in-sql-server-2005

  SQL 2000/2005/2008/2012 DBA - MCTS/MCITP

• avdhut.k

  SSCrazy

  Points: 2834

  More actions

  January 16, 2014 at 1:50 am

  #1680554

  Hi,

  But my requirement is to insert into table from a select query conationg for "xml keyword"