title: Select number of deleted records with t-SQL
body: <p>I can't seem to figure out how to select the number of previously deleted records with SQL Server 2008. Is it something like this?</p>
  
  <pre><code>DELETE FROM [table] WHERE [id]=10
  SELECT SCOPE_IDENTITY()
  </code></pre>