34,591
社区成员
发帖
与我相关
我的任务
分享
EXEC master..xp_cmdshell 'bcp test.dbo.book1 in D:\test\2010-3-2.txt -t"\t" -c -S"127.0.0.1" -U"sa" -P"30687724"'
NULL
开始复制...
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]对于造型说明无效的字符值
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]对于造型说明无效的字符值
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]对于造型说明无效的字符值
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]对于造型说明无效的字符值
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]对于造型说明无效的字符值
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]对于造型说明无效的字符值
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]对于造型说明无效的字符值
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]对于造型说明无效的字符值
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]对于造型说明无效的字符值
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]对于造型说明无效的字符值
NULL
BCP 复制 in 失败
NULL
-- 建导入的文件D:\0110.txt 内容:
日期 时间 CGI BSC TCH话务量
2010-3-3 0 460-00-32808-39011 BSC07 4.240695953
2010-3-3 0 460-00-32808-39012 BSC07 2.32038331
-- 建测试表
create table book1
(a date,b int,c varchar(20), d varchar(10), e decimal(10,7))
-- bulk insert导入
bulk insert DBAP.dbo.book1
from 'D:\0110.txt'
with
( FIELDTERMINATOR =' ', -- 分隔符
ROWTERMINATOR ='\n',
KILOBYTES_PER_BATCH=5000,
firstrow=2
)
select * from book1
a b c d e
---------- ----------- -------------------- ---------- ---------------------------------------
2010-03-03 0 460-00-32808-39011 BSC07 4.2406960
2010-03-03 0 460-00-32808-39012 BSC07 2.3203833
(2 row(s) affected)
VARCHAR()
日期 时间 CGI BSC TCH话务量 Sdcch话务量 SDCCH试呼总次数 SDCCH溢出总次数 无线接通率 话音溢出总次数(含切换) 话音信道试呼总次数(含切换) 话音溢出总次数(不含切换) 话音信道试呼总次数(不含切换)
2010-3-3 0 460-00-32808-39011 BSC07 4.240695953 1.903491497 1852 0 100.00% 0 451 0 91
2010-3-3 0 460-00-32808-39012 BSC07 2.32038331 0.691454172 714 0 100.00% 0 230 0 39