Interactive BCP

Interactive BCP is used to selectively import or export data. Interactive mode is automatically activated when the following switches are not included in the BCP statement:

-n (native format)

-N (native format for non-character data and Unicode native format for character data)

-c (character format)

-f (format file)

-w (Unicode native format)

Through the use of interactive prompts, you can tailor BCP to your import and export specifications. Interactive BCP prompts you for four pieces of information:

  • File storage type

  • Prefix length

  • Field length

  • Field and row terminator

The following are sample interactive BCP prompts:

 Enter the file storage type of field discounttype [char]: Enter prefix-length of field discounttype [0]: Enter length ...

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.