title: Deleting multiple rows with a single query
body: <p>This should be a straightforward question, but I haven't found a clear answer yet. Does anyone know how to delete multiple rows from a single table in SQL Server 2005, using a single query? I wondered if it might just be the opposite of inserting multiple rows, using the <code>UNION ALL</code> method. So would this work? :</p>
  
  <pre><code>DELETE FROM Table (Name, Location)
  SELECT 'Name1', 'Location1'
  UNION ALL
  SELECT 'Name2', 'Location2'
  UNION ALL
  SELECT 'Name3', 'Location3'
  etc...
  </code></pre>
  
  <p><strong>EDIT</strong>: I should point out that this is a link table that I'm trying to remove records from. There is no primary key, and any of the columns' values may repeat. So I need to be sure that both columns contain a certain value for the same record before I remove the record. </p>