title: Delete from two related tables by useng ID returned from the first one
body: <p>I want to delete 2 records from related tables(the record with the same id of foreign key) by using <code>sqlcommand</code>.
  Is there any method like <code>SCOPE_IDENTITY</code> that return the last ID has been deleted?
  I don't want to use <code>ON DELETE CASCADE</code> Constraint. Any idea?</p>
  
  <p>Thanks.</p>