您可以在交易中IDENTITY使用插入列SET IDENTITY_INSERT ON中（不要忘了之后将其关闭）：
如何使用SQL Server 2008打开和关闭IDENTITY_INSERT？
SET IDENTITY_INSERT FPSDB_new.dbo.Form_Attachment ON
INSERT INTO FPSDB_new.dbo.Form_Attachment ( AttachmentID, CategoryID )
SELECT
AttachmentID,
CategoryID
FROM
FPSDB.dbo.Form_Attachment
SET IDENTITY_INSERT FPSDB_new.dbo.Form_Attachment OFF
602392714
清零编程群