setidentity_insert tableName on
insert into tableName (columnName) select top 10 columnName fromoldTableName b
setidentity_insert tableName off
setidentity_insert tableName on
insert into tableName (columnName) select top 10 columnName fromoldTableName b
setidentity_insert tableName off