create table test ( id bigint identity(1,1) not null, name varchar(10) not null, nameId varchar(10) not null, workId varchar(10) not null, srcCode varchar(21) not null, destCode varchar(21) not null, Typename varchar(4) not null, fCode varchar(21) not null, feeType varchar(4) not null, fee varchar(4) not null, sendTime datetime not null, re1 varchar(50) null, re2 varchar(50) null, primary key (id) )
真的不行,如果你将表定义中 sendTime datetime not null 改为: sendTime varchar(24) not null导入的数据就很正常.
确实不行,如果将表定义 sendTime datetime not null改为: sendTime varchar(24) not null就行.
create table ##test ( id bigint identity(1,1) not null, name varchar(10) not null, nameId varchar(10) not null, workId varchar(10) not null, srcCode varchar(21) not null, destCode varchar(21) not null, Typename varchar(4) not null, fCode varchar(21) not null, feeType varchar(4) not null, fee varchar(4) not null, sendTime varchar(100) not null, re1 varchar(50) null, re2 varchar(50) null, primary key (id) )bulk insert ##test from 'f:\data.DAT' with (formatfile='f:\formatfile.fmt')insert test select * from ##testdrop table ##test
一下数据用bulk insert怎么写?abc abc abc a sdf dsa s asd akk ksd a sss sss s als aaa aaa a aaa aaa aaa a sld l四个字段,某些字段有时有字符有时没有,某些列后面空一格,某些列后面空三格。怎么办?严重感谢。
(
id bigint identity(1,1) not null,
name varchar(10) not null,
nameId varchar(10) not null, workId varchar(10) not null, srcCode varchar(21) not null, destCode varchar(21) not null, Typename varchar(4) not null,
fCode varchar(21) not null, feeType varchar(4) not null, fee varchar(4) not null, sendTime datetime not null,
re1 varchar(50) null, re2 varchar(50) null,
primary key (id)
)
sendTime datetime not null
改为:
sendTime varchar(24) not null导入的数据就很正常.
sendTime datetime not null改为:
sendTime varchar(24) not null就行.
(
id bigint identity(1,1) not null,
name varchar(10) not null,
nameId varchar(10) not null, workId varchar(10) not null, srcCode varchar(21) not null, destCode varchar(21) not null, Typename varchar(4) not null,
fCode varchar(21) not null, feeType varchar(4) not null, fee varchar(4) not null, sendTime varchar(100) not null,
re1 varchar(50) null, re2 varchar(50) null,
primary key (id)
)bulk insert ##test
from 'f:\data.DAT'
with (formatfile='f:\formatfile.fmt')insert test select * from ##testdrop table ##test
sdf dsa s
asd akk ksd a
sss sss s
als aaa aaa a
aaa aaa aaa a
sld l四个字段,某些字段有时有字符有时没有,某些列后面空一格,某些列后面空三格。怎么办?严重感谢。