All Articles on SQL - Purge Move Data

Bulk insert of records into a table, from another database table, preserving the original identity

Posted 09 February 2010 - Category SQL Sub Category Purge Move Data

This code example shows the process of keeping identity values when inserting records from another table. It also makes sure that a transaction covers the whole operation, so that any errors will rollback the database.

Choose from the right hand menu to see full lists within subcategories