O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required