txt文件导入Sql Server数据库表方法

create table tablet( 
 A nvarchar(100),
 b nvarchar(100),
 C nvarchar(100)
)
Bulk insert Codematic..tablet from 'c:\dd.txt'
with(
    datafiletype = 'char',
    fieldterminator = '|',
    rowterminator = '\n'
)
select * from tablet

BULK INSERT dbname..user FROM 'c:\123.txt'
WITH (
  DATAFILETYPE = 'char',
  FIELDTERMINATOR = ',',
  ROWTERMINATOR = '\n'
)