title: What is the best way to loop over a table's rows?
body: <p>What is the best way to loop over a database table's rows in SQL Server 2008 R2?</p>
  
  <p>I am looking for something which is fairly similar to writing foreach ( ) and quite performant.</p>
  
  <p>Thanks</p>