为什么只能导入一条数据呢^_^

Question

/*文本格式2008-10-29 16:08:35,123456789,3
2008-10-29 16:12:57,223456789,4
2008-10-29 16:12:57,323456789,5
*//*数据库格式1 Times datetime 8 1
0 tiaoma nvarchar 50 1
0 Nums int         4 1
*/现在将文本文件里面的记录导入到sql数据库中，为什么只导入一条记录进去呢，应该是三条啊exec master..xp_cmdshell 'bcp cangku..Data_In in "C:\Documents and Settings\Administrator\桌面\仓库\入库.txt" -t, -r\r -c -m99999 -S(local) -T'

Answer 1

bulk insert test
from 'E:\Test.txt'
with(
        FIELDTERMINATOR = ',',
        ROWTERMINATOR = '\n'        )

Answer 2

参考:BULK INSERT Northwind.dbo.[Order Details]
   FROM 'f:\orders\lineitem.tbl'
   WITH 
      (
         FIELDTERMINATOR = '|',
         ROWTERMINATOR = '|\n'
      )

Answer 3

if object_id('test')is not null drop table test
go
create table test( Times datetime ,tiaoma nvarchar(50),nums int )
bulk insert test
from 'E:\Test.txt'
with(
        FIELDTERMINATOR = ',',
        ROWTERMINATOR = '\n'        )
select * from test
/*Times                                                  tiaoma                                             nums        
------------------------------------------------------ -------------------------------------------------- ----------- 
2008-10-29 16:08:35.000                                123456789                                          3
2008-10-29 16:12:57.000                                223456789                                          4
2008-10-29 16:12:57.000                                323456789                                          5*/