title: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows
body: <p>I got this error after I have inserted <code>data</code> from <code>excel</code> file to <code>sql server</code>. According to the data on excel the table created by the <code>SSMS</code> automatically and ended up with 7 rows of <code>null</code> values for all fields. </p>
  
  <p>Error was,</p>
  
  <blockquote>
    <p>The row value(s) updated or deleted either do not make the row unique
    or they alter multiple rows(7 rows)</p>
  </blockquote>
  
  <p>This is interesting because when I search in <code>stackoverflow</code> I got this <a href="https://stackoverflow.com/questions/36859306/the-row-values-updated-or-deleted-either-do-not-make-the-row-unique-or-they-alte">answer</a> and it doesn't help me since I have only <code>null</code> values on my table for 7 rows that I want to delete.   </p>
  
  <p>I use below <code>T-sql</code> but it affects no rows,</p>
  
  <pre><code>Delete top(1) from [tableName] where [columnName]= NULL
  
  Delete top(1) from [tableName] where [columnName]= 'NULL'
  </code></pre>
  
  <p>Help to delete that 7 rows are much appreciated.</p>