Home › SQL Server › SQL Server XML Data Type Operations

Combining two XML documents using TSQL


Combine two XML documents

declare @a XML, @b XML
SELECT @a = '
    <Name>
        <First>jacob</First>
        <Last>sebastian</Last>
    </Name>'
SELECT @b = '
    <Name>
        <First>mike</First>
        <Last>smith</Last>
    </Name>'    

SELECT
    @a, 
    @b
FOR XML PATH('')

/*
Result
--------------------------
<Name>
  <First>jacob</First>
  <Last>sebastian</Last>
</Name>
<Name>
  <First>mike</First>
  <Last>smith</Last>
</Name>
*/

Share |
 Cant find the page you are looking for?
 Help us to improve by adding the content that you are looking for.
 Leave a feedback
 We look forward to hear your comments and feedback.
  • 4353 reads