SQL bulk insert 大批量汇入，csv文件

1.先建立表

1.建立table 由於不曉得需求 預設都開varchar

CREATE TABLE [dbo].[member_point] (

[ROWNUM] varchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,

[CARDNO] varchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,

[TRANSDATE] varchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,

[AMOUNT] varchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,

[AWARDPOINTS] varchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,

[VOID_AWARDPOINTS] varchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,

[REDEMPOINTS] varchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,

[VOID_REDEMPOINTS] varchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,

[MID] varchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,

[TID] varchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,

[INVOICE] varchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,

[EXPIRYDATE] varchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL

)

ON [PRIMARY]

GO

2.使用sqlserver bulk insert，注意文件位置名称需修改

BULK INSERT member_point

    FROM  'C:/xxxxx/member_point.csv'

    WITH

(

    batchsize=10000,

    FIELDTERMINATOR ='","',

    ROWTERMINATOR ='"\n"',

    FirstRow=2

);