sqlserver大容量导入数据时保留标识值 (二)

GO

INSERT INTO HumanResources.myDepartment

with (KEEPIDENTITY)

(DepartmentID, Name, GroupName, ModifiedDate)

SELECT *

FROM OPENROWSET(BULK 'C:\myDepartment-n.Dat',

FORMATFILE='C:\myDepartment-f-n-x.Xml') as t1;

GO

摘自 qiaolevip