title: Compare between JSON string using openjson in SQL Server 2016
body: <p>I have two scenarios of inserting json string. 
  I check the json string is already exists or not using the below code and then I insert into the table </p>
  
  <pre><code>**Scenario - 1**
  
  
   declare @jsonStr nvarchar(max) = {"Manufacurer": "test", "Model": "A", "Color":"New Color","Thickness":"1 mm"}
          declare @SqlStr nvarchar(max), @counts int
  
          Select @dynamicFilter = Coalesce(@dynamicFilter,'') +' and Json_Value(ItemOfProduct,''$."'+ [key] +'"'') = ''' +[value]+'''' from openjson(jsonStr)
  
          set @SqlStr = 'select @cnt = count(*) from tblTest where '+@dynamicFilter
          Exec sp_executesql @SqlStr, N'@cnt int output', @cnt = @counts output
  
          if(@counts &lt; 1)
          Begin
              //insert the data into the table
          End
  
  
  
  
  **Scenario - 2** 
  
  
  set @jsonStr = {"Manufacurer": "test", "Model": "A", "Color":"New Color"}
      //Do the same above process of inserting
  </code></pre>
  
  <p>In the 2nd Scenario, my data is not getting inserted into table as the count is 1. But I want both the string in scenario 1 and 2 to be treated as different and both the data to be inserted into database. </p>