22,210
社区成员
发帖
与我相关
我的任务
分享
create table t
(id int,date datetime)
--在文本中保存内容为
/*
1 | 20071101 |
2 | 20080112 |
3 | 20080131 |
*/
bulk insert t from 'C:\Documents and Settings\liang\桌面\11.txt'
with
(
datafiletype='char',
fieldterminator='|',
rowterminator='|\n'
)
select * from t
/*
id date
----------- ------------------------------------------------------
1 2007-11-01 00:00:00.000
2 2008-01-12 00:00:00.000
3 2008-01-31 00:00:00.000
(所影响的行数为 3 行)
*/
--上面打错了
[code=SQL]
bulk insert dbo.tmp_src
from 'E:\abc.txt'
with
(
datafiletype='char',
fieldterminator ='¦',
rowterminator= '¦\n'
)
bulk insert dbo.tmp_src
from 'E:\abc.txt'
with
(
datafiletype='char',
fieldterminator = ' ¦',
rowterminator = ' ¦\t '
)
alter table dbo.tmp_src alter column 日期字段 varchar(8)
bulk insert ....
...
...
alter table dbo.tmp_src alter column 日期字段 datetime