select values from xml field sql server

Question

Just looking at my XML field, my rows look like this:

<ReturnData>
  <Header>
    <Type>SAM</Type>
  </Header>
<ReturnData>

I need to get ReturnData/Header/Type value. Please help me. Thanks!

John Cappelletti · Accepted Answer · 2017-04-26 14:23:13Z

1

Declare @YourTable table (ID int, XML xml )
Insert Into @YourTable values 
(1,'<ReturnData><Header><Type>SAM</Type></Header></ReturnData>')

Select A.ID
      ,Type = A.XML.value('(ReturnData/Header/Type)[1]','varchar(100)')
 From @YourTable A

Returns

ID  Type
1   SAM

answered Apr 26, 2017 at 14:23

John Cappelletti

82.3k7 gold badges50 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

select values from xml field sql server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related