title: Move deleted data from a table to another table
body: <p>What is the best way to move the deleted data from a table to another table? Assuming both tables have same column definitions? </p>
  
  <pre><code>EmpTable
  EmpID(PK, identity) EmpName(nvarchar(max)) Picture(varbinary(max)) 
  
  DeletedEmpTable
  DeletedEmpID(PK, identity) EmpID(int) EmpName(nvarchar(max)) Picture(varbinary(max)) 
  </code></pre>