title: How to compare Null values from the database column
body: <p>I have record in my table where Name column has Null value.. and I want to update that record using below query..
  My sql query is:</p>
  
  <pre><code>set @Name=NUll;
  
  update emp set name="gaurav" where name=@Name
  </code></pre>
  
  <p>When I run this query.. It will not update the record.. It does not compare the value <code>Null</code> to column value </p>
  
  <p>How can this be done?</p>