sqlserver BCP还原
USE TrackingDB;
GO
--TRUNCATE TABLE Packaging_Indicator_Mapping; -- (for testing)
BULK INSERT dbo.Packaging_Indicator_Mapping
FROM 'D:\zq\Tracking_HSLB-2021.bcp'
WITH (FORMATFILE = 'D:\zq\FMT\bcp7.fmt');
GO
USE TrackingDB;
GO
--TRUNCATE TABLE Packaging_Indicator_Mapping; -- (for testing)
BULK INSERT dbo.Packaging_Indicator_Mapping
FROM 'D:\zq\Tracking_HSLB-2021.bcp'
WITH (FORMATFILE = 'D:\zq\FMT\bcp7.fmt');
GO