title: how to parse Json data in python and load to SQL server?
body: <p>example : </p>
  
  <pre><code>product = ["Neil O'Biran",'ahs9029','One thing that is "contant" is',None]
  </code></pre>
  
  <p>now inorder to insert into sql server, we need everythin in single quotes, so i used. </p>
  
  <pre><code>','.join('"{0}"'.format(w) for w in product)
  </code></pre>
  
  <p>this will give output</p>
  
  <pre><code>'Neil O'Brian','ahs9029','One thing that is "contant" is','None'
  </code></pre>
  
  <p>My question is how do we get rid of the single quote in the name and the double quotes in "Constant" ?</p>
  
  <p>So that everything is encompassed in single quotes and can be inserted into sql server using stored procedures in my case.</p>
  
  <p>Only values containing single quotes can be inserted into sql server, with insert command, how do you handle values which are as dynamic as i h ave showed in the example, in one case a name contains a single quote, in the other there are double quotes in the strings. How do you replace them all before inserting ?</p>