sql server bulk insert

BULK INSERT [HumanResources].[Shift] FROM '$(SqlSamplesSourceDataPath)AdventureWorks 2008 OLTP\Shift.csv'
WITH (
    CHECK_CONSTRAINTS,
    CODEPAGE='ACP',
    DATAFILETYPE='char',
    FIELDTERMINATOR='\t',
    ROWTERMINATOR='\n',
    KEEPIDENTITY,
    TABLOCK
);

转载于:https://www.cnblogs.com/joe-yang/archive/2009/10/14/1582955.html