title: SQL INSERT INTO: comma as decimal
body: <p>My problem is that my customer runs his SQL Server on a Windows box and the country settings are set to "Germany".</p>
  
  <p>This means, a decimal point is NOT a point <code>.</code>, it's a comma <code>,</code>!</p>
  
  <p>Inserting a double value to the database works like this</p>
  
  <pre><code>INSERT INTO myTable (myPrice) VALUES (16,5)
  </code></pre>
  
  <p>Works fine, so far.</p>
  
  <p>The problem comes up if there is more than one value with decimal places in the statement like</p>
  
  <pre><code>INSERT INTO myTable (myPrice, myAmount) VALUES (16,5,10)
  </code></pre>
  
  <p>I get the error </p>
  
  <blockquote>
    <p>Number of query values and destination fields are not the same.</p>
  </blockquote>
  
  <p>Can I somehow "delimit" the values? Tried to add brackets around but this does not work.</p>
  
  <p>Unfortunately I cannot change the language settings of the OS or the database because I am just writing some add-ons to an existing application.</p>
  
  <p>Thank you!
  ev</p>