how to get with out erroe in XML

• parthi-1705

  SSCrazy Eights

  Points: 9277

  More actions

  January 30, 2010 at 3:49 am

  #386210

  HI

  SELECT ProductModelID, Name

  FROM Production.ProductModel

  WHERE ProductModelID=122

  or ProductModelID=119

  FOR XML RAW

  O/P:

  <row ProductModelID="119" Name="Bike Wash"/><row ProductModelID="122" Name="All-Purpose Bike Stand"/>

  If i save this in XML and Run it is getting error(XML document cannot contain multiple root level elements ) why?, how to get this without error i need to save this in XML and run

  Which modes(RAW,AUTO,EXPLICIT,PATH) can be better

  Thanks
  Parthi

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  January 30, 2010 at 3:58 am

  #1111160

  Hi

  You have to specify a ROOT element:

  SELECT ProductModelID, Name

  FROM Production.ProductModel

  WHERE ProductModelID=122

  or ProductModelID=119

  FOR XML RAW, ROOT('MyRoot')

  Greets

  Flo