title: Insert decimal with comma is interpreted as two values
body: <p>I'm creating an ssrs report and creating a mockdata sql script.<br>
  In the script I want to insert a decimal value like so:</p>
  
  <pre><code>declare @tempTable table(
    aString varchar(50),
    aDecimal decimal(5,2)
  )
  
  insert into @tempTable
  values ("somestring", 1,23)
  </code></pre>
  
  <p>The values after "someString" are actually one decimal value with a comma as decimal separator. SQL interprets this as separate values though and hence throws an error about too many values for the number of columns. How to go about this?</p>
  
  <p><strong>UPDATE</strong><br>
  To clarify: I'm in a region where '.' is a thousand separator and ',' is a decimal separator.<br>
  Putting it in between quotes doesn't work either. It gives me the <code>Error converting data type varchar to numeric</code> message</p>