Loading

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
);
posted @ 2009-10-14 09:28  .net's  阅读(384)  评论(0编辑  收藏  举报