Retrieve Data from XML Field of a table

• Dfalir

  SSCrazy

  Points: 2486

  More actions

  June 17, 2008 at 8:26 am

  #381198

  Guys hi,

  i have a table called filteredarticle that has an xml column named articlexml. From this column i want to retrieve the text.

  How can i do it ?

  Can you help pls?

  Regards,

  DF

  ---

  "If you want to get to the top, prepare to kiss alot of bottom"
  

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  June 17, 2008 at 10:30 am

  #829923

  [font="Verdana"]OPENXML will help you in such case.[/font]

  MH-09-AM-8694

• Grant Fritchey

  SSC Guru

  Points: 397721

  More actions

  June 17, 2008 at 11:43 am

  #829954

  Look into using the NODES method. Here's an example from BOL:

  SELECT C.query('.') as result

  FROM Production.ProductModel

  CROSS APPLY Instructions.nodes('

  declare namespace MI="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions";

  /MI:root/MI:Location') as T(C)

  WHERE ProductModelID=7

  ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software