title: Move row from one table to another?
body: <p>I have two tables with the same column definitions.  I need to move (not copy) a row from one table to another.  Before I go off and use INSERT INTO/DELETE (in a transaction), is there a smarter way?</p>
  
  <p>SQL Server 2005</p>