The Bulk-Copy Program

The proper usage of BCP is

bcp {dbtable | query} {in | out | queryout | format} datafile 

followed by one or more switches.

In this syntax,


is the database_name + owner + table_name|view_name (for example, Northwind.dbo.customers or “Northwind.dbo.customers”):


is the name of the database in which the specified table or view resides. If not specified, this is the default database for the user.


is the name of the owner of the table or view.

						table_name | view_name

is the name of the destination table or view when copying data in to SQL Server (in), and the source table when copying data from SQL Server (out).


is a Transact-SQL query that returns a resultset. queryout must also be ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.