Retreiving specific data from xml to database table

• amitkumar 69249

  Newbie

  Points: 1

  More actions

  July 10, 2010 at 12:44 pm

  #98768

  i am trying to retrieve specific data from XML file to Database table through query but i am not able to Specify the particlular data in Query .. plz can help ?

  sample Query

  SELECT *

  FROM OPENROWSET (BULK

  'E:\EWX00000000003186\data.xml', SINGLE_BLOB) AS TEMP

  but i want only one column data not all

  example

  SELECT A1

  FROM OPENROWSET (BULK

  'E:\EWX00000000003186\data.xml', SINGLE_BLOB) AS TEMP

  Thanks in Advance

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739567

  More actions

  July 11, 2010 at 9:05 am

  #1191221

  Which attribute/element are you looking for? Can you give a little more detail?

  Does this help? http://www.lockergnome.com/sqlsquirrel/2008/05/23/how-to-turn-imported-xml-into-a-relational-format-in-sql-server-2005/

  I think you might need to import this into a temp/staging table and then query things. Or perhaps you can just query from the file instead of using * and read an attribute.