Help with reading xml
If your question is about MS-Sql you can use this syntax:




DECLARE @data xml;

SET @data = 
'&lt;Message&gt;
  &lt;Code&gt;Hello &lt;/Code&gt;
  &lt;Code&gt;bye &lt;/Code&gt;
&lt;/Message&gt;';

SELECT d.lin.value('.', 'varchar(100)') as [Code]
FROM   @data.nodes('Message/Code') d(lin)
GO



| Code   |
| :----- |
| Hello  |
| bye    |



dbfiddle here