select * into dbo.hwz_test
from dbo.Employeedata where 1=2
truncate table dbo.hwz_test
BULK
INSERT dbo.hwz_test
FROM 'C:\Backups\epbx.csv'
WITH
(
FIRSTROW=2,
FIELDTERMINATOR =',',
ROWTERMINATOR ='\n',
CODEPAGE ='RAW',
DATAFILETYPe='char'
)
begin tran
insert into dbo.
Employeedata
select * from dbo.hwz_test;
commit tran;
问题，导出的时候，会报空值NULL认为不是空值，而是
1. 字符串类型直接导入
2. 如果是数字或日期类型，会报类型转换错误
解决方法：把NULL全部删除为空串
,NULL,改为,,
阅读(6350) | 评论(0) | 转发(0) |
