title: Merge two JSON Objects in MS SQL
body: <p>I have two json objects :</p>
  <pre><code>&quot;Celebrity&quot;: [
      {
        &quot;Name&quot;: &quot;SRK&quot;,
        &quot;Surname&quot;: &quot;Kajol&quot;
  },{
       &quot;Name&quot;: &quot;Ajay&quot;,
       &quot;Surname&quot;: &quot;Devgan&quot;
  }]
  
  &quot;Cricketer&quot;: [
      {
        &quot;Name&quot;: &quot;Virat&quot;,
        &quot;Surname&quot;: &quot;Kohli&quot;
  },{
       &quot;Name&quot;: &quot;Sachin&quot;,
       &quot;Surname&quot;: &quot;Tendulkar&quot;
  }]
  </code></pre>
  <p>I want to merge the above two arrays into a single JSON array:</p>
  <pre><code>{&quot;Celebrity&quot;: [
      {
        &quot;Name&quot;: &quot;SRK&quot;,
        &quot;Surname&quot;: &quot;Kajol&quot;
  },{
       &quot;Name&quot;: &quot;Ajay&quot;,
       &quot;Surname&quot;: &quot;Devgan&quot;
  }],
  
  &quot;Cricketer&quot;: [
      {
        &quot;Name&quot;: &quot;Virat&quot;,
        &quot;Surname&quot;: &quot;Kohli&quot;
  },{
       &quot;Name&quot;: &quot;Sachin&quot;,
       &quot;Surname&quot;: &quot;Tendulkar&quot;
  }]}
  </code></pre>
  <p>How to I do this merge in MS sql ?</p>