SQL將外顯值插入資料表的識別欄位中

SET IDENTITY_INSERT Table1 ON;

INSERT INTO Table1 (KeyFLD, FLD1)
SELECT KeyFLD, FLD1
FROM [Srv_Remote].[DB1].[dbo].[Table1];

SET IDENTITY_INSERT Table1 OFF;