title: How get the T-SQL code to find duplicates?
body: <p>MS Access has a button to generate sql code for finding duplicated rows. I don't know if SQL Server 2005/2008 Managment Studio has this.</p>
  
  <ol>
  <li><p>If it has, please point where</p></li>
  <li><p>If it has not, please tell me how can I have a T-SQL helper for creating code like this.</p></li>
  </ol>