title: Update a column of a table with some percentage of its value and then round it to nearest integer in SQL?
body: <p>Let's suppose I have a table <code>Employee</code> with three columns, <code>EID int</code>, <code>Salary int</code>, <code>Dept varchar</code>.</p>
  
  <p>What I want to do is to increase the salary of every employee by 5% then increased value should be rounded to nearest integer like 2.7 should be stored as 3.</p>
  
  <p>How could this be achieved in a SQL Sever query?</p>
  
  <p>I tried this query but it's not working:</p>
  
  <pre><code>update Employee 
  set Salary = ROUND(Salary * @1.05)
  </code></pre>
  
  <p>but instead it's displaying this error:</p>
  
  <blockquote>
    <p>The round function requires 2 to 3 arguments</p>
  </blockquote>