Chapter 14. Using BCP and BULK INSERT

Orryn Sledge

IN THIS CHAPTER

  • BCP

  • BCP Syntax

  • Permissions Required to Run BCP

  • Character Mode Versus Native Mode

  • Interactive BCP

  • Sample BCP Scripts

  • Modes of Operation

  • BCP and Enforcement of Triggers, Rules, Defaults, Constraints, and Unique Indexes

  • Common BCP Traps

  • BCP Tips

  • BULK INSERT

  • BCP FAQ

You can use various methods to import and export SQL Server data. Almost all systems require some type of data transfer. BCP is the utility provided by SQL Server to transfer data. BULK INSERT was introduced in version 7.0. It provides an import-only Transact-SQL statement that is the fastest way to load data into SQL Server. This chapter discusses the BCP utility in detail and provides an overview of the BULK INSERT statement.

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.

Start your free trial