title: SQL Delete TOP statement
body: <p>my table (sql sever 2000) contains large amount of rows, when i delete row, it extremely slow.</p>
  
  <p>i saw some post/forum that suggest to use a WHILE loop function to delete record by batch.</p>
  
  <p>my sql is:</p>
  
  <pre><code>DELETE FROM Tprs_master where Fincmonth='201109';
  </code></pre>
  
  <p>I had rewrite to:</p>
  
  <pre><code>DELETE FROM(SELECT TOP 100 FROM tprs_master) AS t1 WHERE t1.Fincmonth='201109'
  </code></pre>
  
  <p>but it doesn't work.</p>
  
  <p>how can I rewrite the above sql to DELETE TOP style ? Thanks</p>