title: Update records with conditions on columns
body: <p>I want to update the records <code>name,appid</code> in the <code>table1</code> with matching <code>id</code>. Below statement will update the table1 values with below statement</p>
  
  <pre><code>update table1 set name=@name,appid=@appid where id=@id
  </code></pre>
  
  <p>I want one more condition. Update all the records for this <code>id</code>,but <code>appid</code> should not update if <code>(@appid is null or id=54)</code>. How can i make restriction(condition) on one column(<code>appid</code>). Or should i have to write another update statement? I can format the above query. Please help</p>