首先要保证A库的TableA 表结构和B库的TableB 表结构相同.
SET IDENTITY_INSERT DataBaseB.dbo.TableB ON --导入前开启IDENTITY_INSERT为ON
INSERT INTO DataBaseB.dbo.TableB --目标表
SELECT * FROM DataBaseA.dbo.TableA --源表
SET IDENTITY_INSERT DataBaseB.dbo.TableB OFF --导入后关闭IDENTITY_INSERT为OFF