create table tablet(
A nvarchar(100),
B nvarchar(100),
C nvarchar(100)
)
BULK INSERT ColinTest..tablet FROM 'c:\ddd.txt'
WITH (
DATAFILETYPE = 'char',
FIELDTERMINATOR = '|',
ROWTERMINATOR = '\n'
)
select * from tablet
------------------------------------------------------------------------
A B C
---------- ------ ---------------
10527272 3960 20050701000058|
10527298 6000 20050701000421|
10527302 6000 20050701001340|
10527272 3960 20050701000058|
10527298 6000 20050701000421|
10527302 6000 20050701001340|
(所影响的行数为 6 行)