O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

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

The BULK INSERT Statement and bcp

You can use the bcp command-line utility to export a table or the result of a query to an external data file. You can copy this file over the network or the Internet, or use any media to send it to its destination. It also can be used to import the data file into a single table.

You can use the bcp native mode to export data to and from SQL Server databases. If you export data from SQL Server in native mode, you cannot import that data into any other database system than SQL Server. However, using character-based files provides better flexibility, because the data can be exported to any database system that supports importing from text files.

Tip

Using bcp in native mode, between SQL Server databases, is more ...

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