从文本文件拉数据到数据库表 sql脚本

 

3550B,RMBattery,Quanta,
3550B,RMBattery,Quanta,
3550B,RMBattery,Quanta,

truncate table HPSWAN_tbl_CT

BULK INSERT dbo.HPSWAN_tbl_CT
FROM 'C:\Inetpub\wwwroot\HPSWAN\Dynapack Rome Quanta.txt'
WITH (
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = '\n'
)