SQL Server FUN - Identity insert

Insert in identity column for a table

Sometimes there is a need to insert data into a table that has identity column. Example when you would like to restore a table from a backup including the same IDs so integrity is maintained. Here is simple script

–set identity insert on

set identity_insert <table_name> on

–set identity insert off

set identity_insert <table_name> off

 

SQL Server FUN - Identity insert