title: How to update a field of a table with some percentage of its value in SQL?
body: <p>Let suppose I have a table Employee, which have three field i.e EID , Salary, Dept</p>
  
  <p>What I want to do is to increase the salary of every employee of Department 'Accounts' by 5%.</p>
  
  <p>How this could be achieved in SQL Sever Query?</p>
  
  <p>Kindly help me out!</p>
  
  <p>Cheers</p>