title: Increase each number value by 15% in MSSQL
body: <p>I have a table <strong>Emp</strong> with a <strong>Name</strong> and <strong>Salary</strong> columns respectively. I want to increase each salary by 15% in <strong>MSSQL</strong>. </p>
  
  <p>The query below is just for a single update and I still can't get it done...</p>
  
  <pre><code>UPDATE    Emp
  SET       Salary = '(@Salary / 100) * 15 + @salary'
  
  WHERE Name='Zangiv'
  </code></pre>
  
  <p>I need a single query statement to update multiple rows at once.</p>
  
  <p>Thanks in advance</p>