title: Difference between ColumnName = Null and ColumnName Is Null in SQL Server
body: <p>What is the difference between <code>ColumnName = Null</code> and <code>ColumnName Is Null</code> in SQL Server? I have researched about this but I didn't get any clarification.</p>
  
  <p>Actually I want to retrieve column has null value</p>
  
  <pre><code>Select * from Table1 where column1 is null 
  </code></pre>
  
  <p>This query returning expected result but the following query not giving</p>
  
  <pre><code> Select * from Table1 where column1 = null 
  </code></pre>