title: Query produced from string concatenation fails with `Incorrect syntax near the keyword WHERE`
body: <p>I want to insert values in two tables in the same time. The first value is integer type 
  <em>Example</em> 
  <a href="https://i.stack.imgur.com/Ro1Jh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ro1Jh.png" alt="enter image description here"></a></p>
  
  <p>I am giving an input like <strong>$5000</strong> this is my first value after i am converting the this value<br>
  <code>quotvalue = Val(((finalpayment.Text) / 100) * 2)</code></p>
  
  <p>Then I want to insert this two values first in <em>textbox</em> and second is the <em>quotvalue</em> </p>
  
  <p>I am using  <strong>SQL server 2008</strong> there i have two tables
  <a href="https://i.stack.imgur.com/RQbUC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RQbUC.png" alt="enter image description here"></a></p>
  
  <p>Among these two table I am inputting the values in <strong>Project_Progress</strong> and converting the value <strong>final_payment</strong> after I want to insert this value in <strong>Emplyee</strong> table column <strong>insentives</strong></p>
  
  <p>This is my sample code in <strong>VB.NET</strong> </p>
  
  <pre><code>myconnection = New SqlConnection(strconnection)
          myconnection.Open()
          quotvalue = Val(((finalpayment.Text) / 100) * 2)
          myquery &amp;= "insert into Project_Progress (Project_id,client_id, ex_id, final_payment, dateof_payment, stattus) values('" &amp; txtprjectid.Text &amp; "','" &amp; clientid.Text &amp; "','" &amp; exid.Text &amp; "','" &amp; finalpayment.Text &amp; "', '" &amp; dateofquot.Text &amp; "', '" &amp; txtstatus.Text &amp; "')"
          myquery &amp;= "insert into Emplyee (insentive) values('" &amp; quotvalue &amp; "') WHERE  Project_Progress.ex_id = Emplyee.Emp_ID "
          mycommand = New SqlCommand(myquery, myconnection)
          mycommand.ExecuteNonQuery()
          myconnection.Close()
  </code></pre>
  
  <p>After executing the code this problem is occurring</p>
  
  <p><a href="https://i.stack.imgur.com/uP07C.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uP07C.png" alt="enter image description here"></a> </p>
  
  <p>please help &amp; suggest me what should i do </p>