Summary
The following is BCP and BULK INSERT summary information:
BCP and BULK INSERT use three file types to transfer data: character mode, native mode, and Unicode. Character mode is ASCII text, and native mode is a SQL Server file type. Character mode is usually easier to work with.
When working with fixed-length ASCII files, always use the char data type and 0 prefix length.
To skip a column in interactive BCP, enter 0 prefix length, 0 length, and no terminator.
When importing data, BCP has two modes of operation: fast and slow. Fast mode bypasses the transaction log; slow mode posts all data inserts to the transaction log.
To achieve fast mode BCP, set the database option SELECT INTO/BULKCOPY to TRUE, drop the indexes on the target table, drop ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
