title: How to insert JSON file data to SQL Server table using sql command
body: <p>I am not so familiar with SQL.</p>
  <p>I have a table in my SQL Server database called <code>Product</code></p>
  <pre><code>CREATE TABLE [dbo].[Product] (
  [Age]          INT           NULL,
  [Name]         NVARCHAR (50) NULL,
  [Id]           NVARCHAR (50) NULL,
  [Price]        DECIMAL (18)  NULL,
  [ImageUrl]     NVARCHAR (50) NULL,
  [Snippet]      NVARCHAR (50) NULL
  )
  </code></pre>
  <p>I have a JSON file (which locates in <code>D:\demo\myjson.json</code>) where stores all my product info like:</p>
  <pre><code>[
    {
        &quot;Age&quot;: 0, 
        &quot;Id&quot;: &quot;motorola-xoom-with-wi-fi&quot;, 
        &quot;ImageUrl&quot;: &quot;static/imgs/phones/motorola-xoom-with-wi-fi.0.jpg&quot;, 
        &quot;Name&quot;: &quot;Motorola XOOM\u2122 with Wi-Fi&quot;, 
        &quot;Price&quot;:5000,
        &quot;Snippet&quot;: &quot;The Next, Next Generation\r\n\r\nExperience the future with Motorola XOOM with Wi-Fi, the world's first tablet powered by Android 3.0 (Honeycomb).&quot;
    }, 
    {
        &quot;Age&quot;: 1, 
        &quot;Id&quot;: &quot;motorola-xoom&quot;, 
        &quot;ImageUrl&quot;: &quot;static/imgs/phones/motorola-xoom.0.jpg&quot;, 
        &quot;Name&quot;: &quot;MOTOROLA XOOM\u2122&quot;, 
        &quot;Price&quot;:5000,
        &quot;Snippet&quot;: &quot;The Next, Next Generation\n\nExperience the future with MOTOROLA XOOM, the world's first tablet powered by Android 3.0 (Honeycomb).&quot;
    }
  
  ]
  </code></pre>
  <p>How can I write sql to get this file and import data into my <code>Product</code> table instead of manually doing this?</p>
  <p>I am using SQL Server 2016 and SSMS.</p>