Create table H2T_Sp_Dm
(Spdm varchar(10),
Spmc varchar(100),
Dwdm varchar(5),
Jldw varchar(20)
CONSTRAINT Pk_H2T_Sp_Dm PRIMARY KEY(spdm)
)
go

bulk insert H2T_Sp_Dm
from 'c:\abcd.txt'
with
      (
         FIELDTERMINATOR = ' ',
         ROWTERMINATOR = '\n'
      )
select * from H2T_Sp_Dm

drop table H2T_Sp_Dm
/*
Spdm       Spmc                                                                                                 Dwdm  Jldw                
---------- ---------------------------------------------------------------------------------------------------- ----- --------------------
0101101010 改良种用?危野马                                                                                             NULL   01 头  
0101101090 其他改良种用马                                                                                              NULL   01 头 
0101102010 改良种用的?危野?                                                                                            01    头 
0101102090 改良种用的其他?                                                                                             01    头 
0101901010 非改良种用?危野马                                                                                            01    头 
0101901090 非改良种用马                                                                                               01    头  
0102900090 非改良种用其他牛                                                                                             01    头 
0103100010 改良种用的鹿猪、姬猪                                                                                           01    头 
0103100090 其他改良种用的猪                                                                                             01    头 
0103911010 重量在10公斤以下的其                                                                                          01    头 
0103911090 重量在10公斤以下的其                                                                                          01    头 
0103912010 10?重量<50公斤的其                                                                                         01    头 
0103912090 10?重量<50公斤的其                                                                                         01    头
*/