SET IDENTITY_INSERT
SET IDENTITY_INSERT TableA ON;
INSERT INTO TableA ([Column1],[Column2],[Column3]) SELECT * FROM BackupTable;
SET IDENTITY_INSERT TableA OFF;
絡むを全部指定するのを忘れないでね!
SET IDENTITY_INSERT TableA ON;
INSERT INTO TableA ([Column1],[Column2],[Column3]) SELECT * FROM BackupTable;
SET IDENTITY_INSERT TableA OFF;
絡むを全部指定するのを忘れないでね!