BULK INSERT
BULK INSERT user0
FROM 'd:\u.user'
WITH (
FIELDTERMINATOR = '|',
ROWTERMINATOR = '\n'
)
错误:消息 4863,级别 16,状态 1,第 1 行
第 1 行、第 5 列(zipcode)出现大容量加载数据转换错误(截断)。
表定义:
create table user0(
user0_id varchar(10),
age INT,
gender varchar(1),
occupation varchar(20),
zipcode char(5),
primary key (user0_id),
check(gender = 'M' or gender = 'F')
)
前几行数据:
1|24|M|technician|85711
2|53|F|other|94043
3|23|M|writer|32067
4|24|M|technician|43537